$pdf->startPageNums();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times', '', 32);
$pdf->Ln(70);
$pdf->Cell(0, 1, 'Database I/O Report', 0, 1, 'C');
$pdf->SetFont('Times', '', 20);
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Databases', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$databaseName = $query_row['dbname'];
$environ = $query_row['environ'];
$pdf->Cell(0, 10, 'Database:' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$dio = mysql_query("SELECT * FROM databaseio where date(date) = '{$dt}'");
if (mysql_num_rows($dio)) {
if ($query = mysql_query("SELECT dbuid,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$pdf->SetFont('Arial', '', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'Database I/O Report', 1, 1, 'C', 1);
$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);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'CPU Utilization', 1, 1, 'C', 1);
$pdf->TOC_Entry('CPU Utilization', 0);
while ($query_row = mysql_fetch_assoc($query)) {
$username = $query_row['dbuser'];
$password = $query_row['dbpass'];
$hostname = $query_row['server'];
$portnumber = $query_row['port'];
$databaseName = $query_row['dbname'];
}
$query = mysql_query("select * from alerts inner join alertdesc where alerts.desc_id = alertdesc.desc_id and alerts.dbid='{$currentdb}' and date(alerts.date)>DATE_SUB(NOW(), INTERVAL 1 MONTH)");
if (mysql_num_rows($query)) {
$pdf->AddPage();
$pdf->Ln(3);
$pdf->SetFont('Arial', '', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'Monitored database', 1, 1, 'C', 1);
$pdf->TOC_Entry('Monitored Database', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
$pdf->Cell(0, 10, 'Database Name:- ' . $databaseName, 0, 1, 'L');
$pdf->Ln(10);
$pdf->SetFont('Times', 'B', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'Alerts Summary', 1, 1, 'C', 1);
$pdf->TOC_Entry('Alerts Summary', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->ln(1);
$pdf->AddCol('date', 35, 'Date', 'C');
$pdf->AddCol('time', 35, 'Time', 'C');
$pdf->AddCol('alerttype', 37, 'Type', 'C');
$pdf->AddCol('alertdisc', 170, 'Description');
$pdf->startPageNums();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times', '', 32);
$pdf->Ln(70);
$pdf->Cell(0, 1, 'Database User I/O Report', 0, 1, 'C');
$pdf->SetFont('Times', '', 19);
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Databases', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$databaseName = $query_row['dbname'];
$environ = $query_row['environ'];
$pdf->Cell(0, 10, 'Database:' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$userio = mysql_query("SELECT * FROM userio where date(date) = '{$dt}'");
if (mysql_num_rows($userio)) {
if ($query = mysql_query("SELECT dbuid,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$pdf->SetFont('Arial', '', 20);
$pdf->Ln(10);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf = new PDF_TOC('L', 'mm', 'A4');
$pdf->startPageNums();
// Instanciation of inherited class
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times', '', 32);
$pdf->Ln(70);
$pdf->Cell(0, 1, 'ALERTS REPORT', 0, 1, 'C');
$pdf->SetFont('Times', '', 19);
include 'sqlconnectver2.php';
$query = mysql_query("SELECT dbuid,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'");
$pdf->AddPage();
$pdf->Ln(3);
$pdf->SetFont('Arial', '', 20);
$pdf->Cell(0, 10, 'Monitored Database Name', 1, 1, 'C');
$pdf->TOC_Entry('Monitored Database Name', 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$databaseName = $query_row['dbname'];
$pdf->Cell(0, 10, 'Database Name:- ' . $databaseName, 0, 1, 'L');
}
if ($query = mysql_query("SELECT dbuid,dbuser,dbpass,server,port,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
while ($query_row = mysql_fetch_assoc($query)) {
$username = $query_row['dbuser'];
$password = $query_row['dbpass'];
$hostname = $query_row['server'];
$portnumber = $query_row['port'];
$databaseName = $query_row['dbname'];
$dbuid = $query_row['dbuid'];
$num = mysql_query("select date(alerts.date) as date,time(alerts.date) as time, alertdesc.alertdisc , alertdesc.alerttype from alerts inner join alertdesc where alerts.desc_id = alertdesc.desc_id and alerts.dbid='{$dbuid}'");
$pdf->AddPage();
$pdf->Ln(70);
$pdf->SetFont('Arial', '', 32);
$pdf->Cell(0, 10, 'Monthly Report', 0, 1, 'C');
$pdf->Ln(10);
$pdf->SetFont('Arial', '', 20);
$pdf->Cell(0, 1, 'From ' . date('d-M-Y', strtotime('-30 days')) . ' to ' . date("d-M-Y"), 0, 1, 'C');
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Database', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$environ = $query_row['environ'];
$databaseName = $query_row['dbname'];
$pdf->Cell(0, 10, 'Database: ' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$pdf->SetFont('Arial', '', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'Alerts Generated', 1, 1, 'C', 1);
$pdf->TOC_Entry('Alerts Generated', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
<?php
require 'toc.php';
$pdf = new PDF_TOC();
$pdf->SetFont('Times', '', 12);
$pdf->AddPage();
$pdf->Cell(0, 5, 'Cover', 0, 1, 'C');
$pdf->AddPage();
$pdf->startPageNums();
$pdf->Cell(0, 5, 'TOC1', 0, 1, 'L');
$pdf->TOC_Entry('TOC1', 0);
$pdf->Cell(0, 5, 'TOC1.1', 0, 1, 'L');
$pdf->TOC_Entry('TOC1.1', 1);
$pdf->AddPage();
$pdf->Cell(0, 5, 'TOC2', 0, 1, 'L');
$pdf->TOC_Entry('TOC2', 0);
$pdf->AddPage();
for ($i = 3; $i <= 80; $i++) {
$pdf->Cell(0, 5, 'TOC' . $i, 0, 1, 'L');
$pdf->TOC_Entry('TOC' . $i, 0);
}
$pdf->stopPageNums();
$pdf->AddPage();
$pdf->Cell(0, 5, 'Unnumbered page', 0, 1, 'L');
//Generate and insert TOC at page 2
$pdf->insertTOC(2);
$pdf->Output();
// Instanciation of inherited class
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times', '', 32);
$pdf->Ln(70);
$pdf->Cell(0, 1, 'Database Long Running Transaction', 0, 1, 'C');
$pdf->SetFont('Times', '', 19);
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Database', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$environ = $query_row['environ'];
$databaseName = $query_row['dbname'];
$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->AliasNbPages();
$pdf->AddPage();
$pdf->Ln(60);
$pdf->SetFont('Times', '', 32);
$pdf->Cell(0, 1, 'Database Area Growth Report', 0, 1, 'C');
$pdf->SetFont('Times', '', 19);
$pdf->SetFont('Times', '', 12);
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Databases', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$databaseName = $query_row['dbname'];
$environ = $query_row['environ'];
$pdf->Cell(0, 10, 'Database:' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$pdf->SetFont('Arial', '', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'Database Area Growth Report', 1, 1, 'C', 1);
$pdf->SetTextColor(0, 0, 0);
$areastatquery = mysql_query(" SELECT * FROM areagrowth where date(date) = '{$dt}'");
if (mysql_num_rows($areastatquery)) {
$pdf->AddPage();
$pdf->Ln(70);
$pdf->SetFont('Arial', '', 32);
$pdf->Cell(0, 10, 'Monthly Report', 0, 1, 'C');
$pdf->Ln(10);
$pdf->SetFont('Arial', '', 20);
$pdf->Cell(0, 1, 'FOR ' . date("F o"), 0, 1, 'C');
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Database', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$environ = $query_row['environ'];
$databaseName = $query_row['dbname'];
$pdf->Cell(0, 10, 'Database: ' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$pdf->SetFont('Arial', '', 20);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
$pdf->Cell(0, 10, 'Alerts Generated', 1, 1, 'C', 1);
$pdf->TOC_Entry('Alerts Generated', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
$pdf = new PDF_TOC('L', 'mm', 'A4');
$pdf->startPageNums();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times', '', 32);
$pdf->Ln(70);
$pdf->Cell(0, 1, 'Database Connection Summary', 0, 1, 'C');
include 'sqlconnectver2.php';
if ($query = mysql_query("SELECT dbuid,dbname,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$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 Databases', 1, 1, 'C', 1);
$pdf->TOC_Entry('List of Databases', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Times', '', 14);
while ($query_row = mysql_fetch_assoc($query)) {
$dbuid = $query_row['dbuid'];
$databaseName = $query_row['dbname'];
$environ = $query_row['environ'];
$pdf->Cell(0, 10, 'Database: ' . $databaseName . ' [' . $environ . ']', 0, 1, 'L');
}
$con = mysql_query("SELECT * FROM connect where date(date) = '{$dt}'");
if (mysql_num_rows($con)) {
if ($query = mysql_query("SELECT dbuid,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) {
$pdf->SetFont('Arial', '', 20);
$pdf->Ln(10);
$pdf->setFillColor(63, 139, 202);
$pdf->SetTextColor(253, 253, 253);
