* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $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 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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); 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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $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 Index 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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $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 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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $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 Table I/O', 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);
* Known Bugs & Issues: * * * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ require 'pdffunc.php'; require 'session.php'; $pdf = new PDF_TOC('L', 'mm', 'A4'); $pdf->startPageNums(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Times', '', 12); $pdf->Ln(70); $pdf->SetFont('Times', '', 32); $pdf->Cell(0, 1, 'ALERTS REPORT', 0, 1, 'C'); $pdf->SetFont('Times', '', 19); $pdf->SetFont('Times', '', 12); include 'sqlconnectver2.php'; $current_user = $_SESSION['login_username']; $currentdb = $_SESSION['dbid']; if ($query = mysql_query("SELECT * FROM configureddb INNER JOIN dbparam where dbparam.dbuid=configureddb.dbuid and dbparam.userid ='{$current_user}' and dbparam.dbuid='{$currentdb}' ")) { while ($query_row = mysql_fetch_assoc($query)) { $username = $query_row['dbuser'];
* * * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $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);
* * * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $pdf = new PDF_TOC('L', 'mm', 'A4'); $pdf->startPageNums(); $pdf->AliasNbPages(); $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);
<?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();
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $pdf = new PDF_TOC('L', 'mm', 'A4'); $pdf->startPageNums(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Times', '', 32); $pdf->Ln(70); $pdf->Cell(0, 1, 'Disk Space 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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); @($dt = $_POST['date']); $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, '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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); 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(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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $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);
* Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); if (isset($_POST['date']) && !empty($_POST['date'])) { $dt = $_POST['date']; $pdf = new PDF_TOC('L', 'mm', 'A4'); $pdf->startPageNums(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Times', '', 32); $pdf->Ln(70); $pdf->Cell(0, 1, 'Memory Utilization Report', 0, 1, 'C'); $pdf->SetFont('Times', '', 19); 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);
* * Author: * * JK Technosoft * http://www.jktech.com * August 11, 2015 * * * History: * */ session_start(); require 'pdffunc.php'; @($current_user = $_SESSION['username']); $dt = $_POST['date']; $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 BI SIZE REPORT', 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);