<?php
session_start();
define('FPDF_FONTPATH', 'fpdf/font');
require('fpdf/fpdf.php');

class PDF extends FPDF{
function Header(){
$this -> Image('../images/logoinvoice.jpg',1,1.5,2.1);
$this -> SetTextColor(128,0,0);
$this -> SetFont('Arial', 'B', '12');
$this -> Cell(16,1,'LAPORAN PENJUALAN',0,0,'C');
$this -> Ln();
$this -> Cell(16,1,'Nadeera Computer',0,0,'C');
$this -> Ln();
}
function Footer(){
$this -> SetY(-2,5);
$this -> Cell(0,1, $this -> PageNo(),0,0,'C');
}
}

require("../config/koneksi.php");

$tahun1 = $_POST['tahun1'];
$bulan1 = $_POST['bulan1'];
$tanggal1 = $_POST['tanggal1'];

$tahun2 = $_POST['tahun2'];
$bulan2 = $_POST['bulan2'];
$tanggal2 = $_POST['tanggal2'];

$sql = mysql_query("SELECT
pesan.id_pesan
, pesan.id_anggota
, pesan.status_pesan
, pesan.total_harga
, pesan.tanggal_pesan
, anggota.nama
, anggota.telepon
FROM
anggota
INNER JOIN pesan
ON anggota.id_anggota = pesan.id_anggota where tanggal_pesan between '$tahun1-$bulan1-$tanggal1' and '$tahun2-$bulan2-$tanggal2' ");

$i=0;

while($data = mysql_fetch_array($sql)){
$cell[$i][0] = $data['id_pesan'];
$cell[$i][1] = $data['nama'];
$cell[$i][2] = $data['telepon'];
$cell[$i][3] = $data['status_pesan'];
$cell[$i][4] = $data['tanggal_pesan'];
$cell[$i][5] = $data['total_harga'];
$i++;
}
$pdf = new PDF('P', 'cm', 'A4');
$pdf -> Open();
//$pdf -> AliasNbPages();
$pdf -> AddPage();
$pdf -> SetFont('Arial', 'B', '9');
$pdf -> SetFillColor(192,192,192);
$pdf -> Cell(1,1,'No',TB, 0, 'L',1);
$pdf -> Cell(2,1,'No.Invoice', TB, 0, 'L',1);
$pdf -> Cell(3,1,'nama', TB, 0, 'L',1);
$pdf -> Cell(3,1,'telepon', TB, 0, 'L',1);
$pdf -> Cell(1,1,'status_pesan', TB, 0, 'C',1);
$pdf -> Cell(3,1,'tanggal_pesan', TB, 0, 'R',1);
$pdf -> Cell(3,1,'total_harga', TB, 0, 'R',1);
$pdf -> Ln();
$pdf -> SetFont('Arial', '', '8');
for ($j = 0; $j < $i; $j++){
$pdf -> Cell(1,1,$j+1,B,0,'L');
$pdf -> Cell(2,1,$cell[$j][0],B,0,'L');
$pdf -> Cell(3,1,$cell[$j][1],B,0,'L');
$pdf -> Cell(3,1,$cell[$j][2],B,0,'L');
$pdf -> Cell(1,1,$cell[$j][3],B,0,'L');
$pdf -> Cell(3,1,$cell[$j][4],B,0,'L');
$pdf -> Cell(3,1,$cell[$j][5],B,0,'L');
$pdf -> Ln();
}
$pdf -> Output();
?>