Пример #1
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 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);
Пример #2
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->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);
Пример #3
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);
Пример #4
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 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);
Пример #5
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 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);
Пример #6
0
 * 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'];
Пример #7
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();
// 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);
Пример #8
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);
Пример #9
0
<?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();
Пример #10
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, '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);
Пример #11
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);
Пример #12
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->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);
Пример #13
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 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);
Пример #14
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);
Пример #15
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 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);