<?php
include 'koneksi.php';
include 'fpdf/terbilang.php';
require('fpdf/fpdf.php');
    $pdf = new FPDF('P','in',array(9.5,11));
    $pdf->AddPage();

    //$no_faktur='1120-001';
    $idinv=$_GET['id'];
    // echo $split;
        $sql1=mysqli_query($conn,"SELECT t.id,t.tgl,t.duedate,t.total,p.nama,p.alamat,p.notelp,sum(td.sub) as subtotal,sum(td.ppn) as ppn,td.disc,sum(td.jumlah) as jumqty,t.discnom,t.ongkir from transaksi t left join pelanggan p on t.pelanggan=p.id left join transaksi_detail td on t.id=td.idtransaksi where t.id='$idinv' order by td.id desc ");
        $ql2=mysqli_query($conn,"SELECT td.jumlah,td.price,td.gross,td.disc,td.discnm,td.netamn,b.nama,td.satuan,b.isi,td.sub,b.hargaper from transaksi_detail td left join barang b on td.barang=b.id  where td.idtransaksi='$idinv'  ");
        $cek=mysqli_num_rows($ql2);
        $nmr=mysqli_num_rows($ql2);
        $data1=mysqli_fetch_array($sql1);
        
        // $pdf->Line(30,74,573,74);
        $pdf->Line(10,23,10,118);
        $pdf->Line(90,23,90,118);
        $pdf->Line(105,23,105,118);
        $pdf->Line(120,23,120,118);
        $pdf->Line(135,23,135,118);
        $pdf->Line(160,23,160,118);
        $pdf->Line(175,23,175,118);
        $pdf->Line(200,23,200,118);
        $pdf->Line(10,118,200,118);

        
        $pdf->SetFont('times','B',11);
        $pdf->Cell(180,0,'FAKTUR PENJUALAN',0,0,'C');
        $pdf->SetFont('times','B',11);
        // $pdf->Cell(0,10,"",0,0);
        $pdf->Cell(0,3,'',0,1);

        $pdf->SetFont('times','',8);
        $pdf->Cell(20,5,'NOMOR ',0,0);
        $pdf->Cell(7,5,': ',0,0);
        $pdf->Cell(100,5,$idinv,0,0);
        // $pdf->SetFont('times','B',20);
        $pdf->Cell(25,5,'Yth : ',0,0);
        // $pdf->Cell(25,10,$nmr,0,0);
        $pdf->Cell(0,5,$data1['nama'],0,0);
        $pdf->Cell(0,5,'',0,1);

        $pdf->Cell(20,5,'TANGGAL',0,0);
        $pdf->Cell(7,5,': ',0,0);
        $pdf->Cell(143,5,date('d-m-Y',strtotime($data1['tgl'])),0,0);
        $pdf->Cell(45,5,'Halaman 1',0,0);
        $pdf->Cell(0,5,'',0,1);
        
        $pdf->Cell(80,5,'Nama Barang',1,0);
        $pdf->Cell(15,5,'Qty',1,0,'C');
        $pdf->Cell(15,5,'Sat',1,0,'C');
        $pdf->Cell(15,5,'@',1,0,'C');
        $pdf->Cell(25,5,'Harga',1,0,'C');
        $pdf->Cell(15,5,'Disc',1,0,'C');
        $pdf->Cell(25,5,'Jumlah',1,0,'C');
        $pdf->Cell(0,5,'',0,1);
        $a=1;
        while ($ds=mysqli_fetch_array($ql2)) {
            $pdf->SetFont('times','',9);
            $pdf->Cell(80,5,$ds['nama'],0,0);
            $pdf->Cell(15,5,number_format($ds['jumlah'],0,',','.'),0,0);
            $pdf->Cell(15,5,$ds['satuan'],0,0);
            $pdf->Cell(15,5,$ds['isi']." ".$ds['hargaper'],0,0);
            $pdf->Cell(25,5,number_format($ds['price'],0,',','.'),0,0);
            $pdf->Cell(15,5,number_format($ds['disc'],0,',','.'),0,0);
            $pdf->Cell(25,5,number_format($ds['gross'],0,',','.'),0,0);
            $pdf->Cell(0,5,'',0,1);
            if ( $a % 18 == 0 ) {
                $pdf->Cell(1,5,'',0,0);
                // $pdf->Cell(327,10,'',0,0);
                $pdf->Cell(17,5,'Jatuh Tempo ',0,0);
                $pdf->Cell(2,5,': ',0,0);
                $pdf->Cell(29,5,date('d-m-Y',strtotime($data1['duedate'])),0,0);
                $pdf->Cell(30,5,'Total Qty',0,0,"R");
                $pdf->Cell(2,5,': ',0,0);
                $pdf->Cell(24,5,number_format($data1['jumqty'],0,",",".")." Pcs",0,0);
                $pdf->Cell(59,5,'Sub Total',0,0,"R");
                $pdf->Cell(2,5,': ',0,0);
                $pdf->Cell(2,5,number_format($data1['subtotal'],0,",","."),0,0);
                $pdf->Cell(0,5,'',0,1);
                
                $pdf->Cell(105,5,'',0,0);
                $pdf->Cell(59,5,'Discount',0,0,"R");
                $pdf->Cell(2,5,': ',0,0);
                $pdf->Cell(7,5,number_format($data1['discnom'],0,",","."),0,0);
                $pdf->Cell(0,5,'',0,1);
                
                if ($data1['ongkir']==0) {
                    // code...
                }else{
                    $pdf->Cell(105,5,'',0,0);
                    $pdf->Cell(59,5,'Ongkir',0,0,"R");
                    $pdf->Cell(2,5,': ',0,0);
                    $pdf->Cell(7,5,number_format($data1['ongkir'],0,",","."),0,0);
                    $pdf->Cell(0,5,'',0,1);
                       
                }
                
                $pdf->Cell(105,5,'',0,0);
                $pdf->Cell(59,5,'Total',0,0,"R");
                $pdf->Cell(2,5,': ',0,0);
                $pdf->Cell(7,5,number_format(round($data1['total'],0),0,",","."),0,0);
                $pdf->Cell(0,5,'',0,1);
                
                $pdf->Cell(5,5,' ',0,0);
                $pdf->Cell(50,-16,'Mengetahui ',0,0);
                $pdf->Cell(50,-16,'Bag Penjualan ',0,0);
                $pdf->Cell(20,-16,'Customer',0,0);
                // $pdf->Cell(7,30,': ',0,0);
                $pdf->Cell(0,5,'',0,1);
                
                $pdf->Cell(5,5,' ',0,0);
                $pdf->Cell(50,5,'(                  )',0,0);
                $pdf->Cell(50,5,'(                       )',0,0);
                $pdf->Cell(50,5,'(               )',0,0);
                // $pdf->Cell(7,30,': ',0,0);
                $pdf->Cell(0,1,'',0,1);
                
                $pdf->SetFont('times','B',11);
                $pdf->Cell(1,20,"a",0,0,'C');
                $pdf->Cell(0,20,'',0,1);
                
            }
            $a++;
        }
        if ($nmr<=18) {
            $pdf->Cell(1,85,'',0,1);
            $pdf->Cell(1,5,'',0,0);
            // $pdf->Cell(327,10,'',0,0);
            $pdf->Cell(17,5,'Jatuh Tempo ',0,0);
            $pdf->Cell(2,5,': ',0,0);
            $pdf->Cell(29,5,date('d-m-Y',strtotime($data1['duedate'])),0,0);
            $pdf->Cell(30,5,'Total Qty',0,0,"R");
            $pdf->Cell(2,5,': ',0,0);
            $pdf->Cell(24,5,number_format($data1['jumqty'],0,",",".")." Pcs",0,0);
            $pdf->Cell(59,5,'Sub Total',0,0,"R");
            $pdf->Cell(2,5,': ',0,0);
            $pdf->Cell(2,5,number_format($data1['subtotal'],0,",","."),0,0);
            $pdf->Cell(0,5,'',0,1);
            
            $pdf->Cell(105,5,'',0,0);
            $pdf->Cell(59,5,'Discount',0,0,"R");
            $pdf->Cell(2,5,': ',0,0);
            $pdf->Cell(7,5,number_format($data1['discnom'],0,",","."),0,0);
            $pdf->Cell(0,5,'',0,1);
            
            if ($data1['ongkir']==0) {
                // code...
            }else{
                $pdf->Cell(105,5,'',0,0);
                $pdf->Cell(59,5,'Ongkir',0,0,"R");
                $pdf->Cell(2,5,': ',0,0);
                $pdf->Cell(7,5,number_format($data1['ongkir'],0,",","."),0,0);
                $pdf->Cell(0,5,'',0,1);
                   
            }
            
            $pdf->Cell(105,5,'',0,0);
            $pdf->Cell(59,5,'Total',0,0,"R");
            $pdf->Cell(2,5,': ',0,0);
            $pdf->Cell(7,5,number_format(round($data1['total'],0),0,",","."),0,0);
            $pdf->Cell(0,5,'',0,1);
            
            $pdf->Cell(5,5,' ',0,0);
            $pdf->Cell(50,-16,'Mengetahui ',0,0);
            $pdf->Cell(50,-16,'Bag Penjualan ',0,0);
            $pdf->Cell(20,-16,'Customer',0,0);
            // $pdf->Cell(7,30,': ',0,0);
            $pdf->Cell(0,5,'',0,1);
            
            $pdf->Cell(5,5,' ',0,0);
            $pdf->Cell(50,5,'(                  )',0,0);
            $pdf->Cell(50,5,'(                       )',0,0);
            $pdf->Cell(50,5,'(               )',0,0);
            // $pdf->Cell(7,30,': ',0,0);
            $pdf->Cell(0,1,'',0,1);
            
        }else{

        }
            

                
            // $pdf->SetFont('Arial','',10);
            // $pdf->Cell(80,12,'',0,0);
            // $pdf->Cell(108,12,'Jl. Ds Tlogomojo RT 05/RW 01 Batangan Kab. Pati',0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(80,12,'',0,0);
            // $pdf->Cell(108,12,'Jl. Jaya Wijaya 06 Kepuh Kiriman Dalam RT 01/RW 01',0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(80,12,'',0,0);
            // $pdf->Cell(108,12,'Waru/Sidoarjo',0,0);
            // $pdf->Cell(25,10,'',0,1);
              
            // $pdf->SetFont('Arial','U',12);
            // $pdf->Cell(80,12,'',0,0);
            // $pdf->Cell(108,12,'Invoice',0,0);
            // $pdf->Cell(25,10,'',0,1);
            
            // $pdf->SetFont('Arial','',8);
            // $pdf->Cell(10,12,'',0,0);
            // $pdf->Cell(15,12,'No Invoice',0,0);
            // $pdf->Cell(3,12,':',0,0);
            // $pdf->Cell(100,12,$id,0,0);
            // $pdf->Cell(23,12,'Tgl Inv',0,0);
            // $pdf->Cell(3,12,':',0,0);
            // $pdf->Cell(3,12,date("d/m/Y", strtotime($data['tglinv'])),0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(10,12,'',0,0);
            // $pdf->Cell(15,12,'Kepada',0,0);
            // $pdf->Cell(3,12,':',0,0);
            // $pdf->Cell(100,12,$data['pelanggan'],0,0);
            // $pdf->Cell(23,12,'Tgl Kegiatan',0,0);
            // $pdf->Cell(3,12,':',0,0);
            // $pdf->Cell(3,12,date("d/m/Y", strtotime($data['tglmasuk'])),0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(28,12,'',0,0);
            // $pdf->Cell(64,12,$data['alamat'],0,0);
            // $pdf->Cell(25,5,'',0,1);

            // $pdf->Cell(28,12,'',0,0);
            // $pdf->Cell(64,12,$data['notelp'],0,0);
            // $pdf->Cell(25,10,'',0,1);

            // $pdf->SetFont('Arial','',8);
            // $pdf->Cell(10,5,'',0,0);
            // $pdf->Cell(40,5,'Unit',1,0,'C');
            // $pdf->Cell(70,5,'Deskripsi',1,0,'C');
            // $pdf->Cell(25,5,'Platno',1,0,'C');
            // $pdf->Cell(35,5,'Jumlah',1,0,'C');
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(10,5,'',0,0);
            // $pdf->Cell(40,5,$data['kendaraan'],1,0);
            // $pdf->Cell(70,5,$data['deskripsi'],1,0);
            // $pdf->Cell(25,5,$data['platno'],1,0);
            // $pdf->Cell(35,5,"Rp.".number_format($data['biaya'],0,".","."),1,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(120,5,'',0,0);
            // $pdf->Cell(25,5,'Tol    :',0,0,'R');
            // $pdf->Cell(35,5,"Rp.".number_format($data['tol'],0,".","."),0,0);
            // $pdf->Cell(25,5,'',0,1);
            // $pdf->Cell(120,5,'',0,0);
            // $pdf->Cell(25,5,'Loading    :',0,0,'R');
            // $pdf->Cell(35,5,"Rp.".number_format($data['loading'],0,".","."),0,0);
            // $pdf->Cell(25,5,'',0,1);
            // $pdf->Cell(120,5,'',0,0);
            // $pdf->Cell(25,5,'Overtime    :',0,0,'R');
            // $pdf->Cell(35,5,"Rp.".number_format($data['extra'],0,".","."),0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(120,5,'',0,0);
            // $pdf->Cell(25,5,'Multi Drop    :',0,0,'R');
            // $pdf->Cell(35,5,"Rp.".number_format($data['mdrop'],0,".","."),0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(120,5,'',0,0);
            // $pdf->Cell(25,5,'Total    :',0,0,'R');
            // $pdf->Cell(35,5,"Rp.".number_format($data['tol']+$data['loading']+$data['extra']+$data['biaya']+$data['mdrop'],0,".","."),0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(10,5,'',0,0);
            // $pdf->Cell(17,5,'Terbilang  :',0,0);
            // $pdf->Cell(25,5,terbilang($data['tol']+$data['loading']+$data['extra']+$data['biaya']+$data['mdrop']). " Rupiah",0,0);
            // $pdf->Cell(35,5,'',0,0);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(10,5,'',0,0);
            // $pdf->Cell(40,5,'Pembayaran Melalui : ',0,1);
            // $pdf->Cell(10,5,'',0,0);
            // $pdf->Cell(70,5,'Bank BCA A/N Dimas Ferry Indryawan',0,1);
            // $pdf->Cell(10,5,'',0,0);
            // $pdf->Cell(25,5,'894 022 1961',0,1);
            // $pdf->Cell(25,5,'',0,1);
            
            // $pdf->Cell(45,5,'',0,0);
            // $pdf->Cell(70,5,'Dibuat  :',0,0);
            // $pdf->Cell(70,5,'Disetujui  :',0,0);
            
    $pdf->Output();

?>