Пример #1
0
                    $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->AddCol('idle', 55, '% Idle ', 'C');
                    $prop = array('HeaderColor' => array(66, 139, 202), 'color1' => array(255, 255, 255), 'color2' => array(255, 255, 255));
                    $pdf->Table("SELECT distinct dbuid,date(cpurep.date)as date,time(cpurep.date) as time,cpurep.user,cpurep.system,cpurep.idle from cpurep,configureddb   WHERE cpurep.dbid=configureddb.dbuid and server='{$hostname}' and date(date) = '{$dt}' ORDER BY date(date) desc", $prop);
                    $pdf->Ln(5);
                } else {
                    $pdf->SetFont('Times', '', 20);
                    $pdf->Ln(20);
                    $pdf->Cell(0, 10, 'No Matching Records Found For Server ' . $hostname, 0, 1, 'C');
                    $pdf->Ln(20);
                }
            }
        }
    } else {
        $pdf->SetFont('Times', '', 26);
        $pdf->Ln(30);
        $pdf->Cell(0, 10, 'No Matching Records Found For Any Database ', 0, 1, 'C');
        $pdf->SetFont('Times', '', 20);
    }
    $pdf->stopPageNums();
    $pdf->insertTOC(2);
    $pdf->AutoPrint(true);
    $pdf->Output();
}