<?php

include "pdf/fpdf.php";
include "../config.php";

$pdf = new FPDF();
$pdf->setFont('Arial','B',8);
$pdf->setXY(25,10); $pdf->cell(30,6,'Laporan Data RTO Network  ');
$pdf->setFont('Arial','B',10);
$sql = mysql_query("select *from logs_rto WHERE ip = '$_POST[ip]'");
$data = mysql_fetch_array($sql);
$pdf->setXY(25,20); $pdf->cell(30,6,'IP ');$pdf->cell(50,6,': '.$data[ip]);
$pdf->setXY(25,26); $pdf->cell(30,6,'Hostname');$pdf->cell(50,6,': '.$data[hostname]);

$y_initial = 41;
$y_axis1 = 35;

$pdf->setFont('Arial','',10);

$pdf->setFillColor(233,233,233);
$pdf->setY($y_axis1);
$pdf->setX(25);


$pdf->cell(10,6,'NO',1,0,'C',1);
$pdf->cell(50,6,'IP',1,0,'C',1);
$pdf->cell(50,6,'Hostname',1,0,'C',1);
$pdf->cell(50,6,'Waktu',1,0,'C',1);

$y = $y_initial + $row;

$nilai = mysql_query("select *from logs_rto
                WHERE ip = '$_POST[ip]'");
$no = 0;
$row = 6;
$page =1;
while ($daftar = mysql_fetch_array($nilai))
{
    $no++;
    $pdf->setY($y);
    $pdf->setX(25);
    $pdf->cell(10,6,$no,1,0,'C');
    $pdf->cell(50,6,$daftar[ip],1,0,'C');
    $pdf->cell(50,6,$daftar[hostname],1,0,'L');
    $pdf->cell(50,6,$daftar[waktu],1,0,'C');

     $y = $y + $row;
     if($no%36==0){
    $pdf->setXY(25,$y); $pdf->cell(30,6,'Page '.$page);
    $pdf->addPage();

    $pdf->setFont('Arial','',10);

    $pdf->setFillColor(233,233,233);
    $pdf->setY($y_axis1);
    $pdf->setX(25);


    $pdf->cell(10,6,'NO',1,0,'C',1);
    $pdf->cell(50,6,'IP',1,0,'C',1);
    $pdf->cell(50,6,'Hostname',1,0,'C',1);
    $pdf->cell(50,6,'Waktu',1,0,'C',1);
    $y=41;
    $page++;
    }


}

$query   = "SELECT COUNT(*) AS jumdata FROM logs_rto where ip ='$_POST[ip]'";
$hasil   = mysql_query($query);
$data    = mysql_fetch_array($hasil);
$jumdata = $data['jumdata'];

$pdf->setXY(25,$y);

$pdf->Cell(20,6,'Jumlah : '.number_format($jumdata,"2",".",""));

$pdf->Output();

?>