prs_lappdf.php

<?php
  session_start(); //Mendapatkan Session
  include('../../../koneksi/koneksi.php');
  $tahun = $_POST['tahun'];
  $bulan = $_POST['bulan'];

  // $query = mysql_query("SELECT a.*, b.*
  //                FROM pendaftaran a
  //                JOIN kms b ON a.no_daftar=b.no_daftar
  //                WHERE YEAR(a.tgl_daftar)='$tahun' AND MONTH(b.tgl_daftar)='$bulan' ");
  // var_dump($query);
  // break;

  date_default_timezone_set('Asia/Jakarta');
  function tglIndonesia($str){
        $tr   = trim($str);
        $str    = str_replace(array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'), array('Minggu', 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jum\'at', 'Sabtu', 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'), $tr);
        return $str;
    }

  ob_start();
  //Report
  require ("../../../html2pdf/html2pdf.class.php");
  $content = ob_get_clean();

  $content.= "
  <style>
  p.kop{
    margin-left:45px;
  }
  </style>
  <table class='kop'>
  <tr>
    <td align='center' width='100'><img src='../../../images/ini.jpeg' width='80' height='80'></td>
    <td width='635'>
      <h4 >POSYANDU DESA SINGA BANGSA</h4>
      <p >Jl. Ciledug Raya, North Petukangan, RT.10/RW.2, Petukangan Utara, Pesanggrahan, South Jakarta, Daerah Khusus Ibukota Jakarta 12260</p>
    </td>
  </tr>
  </table> <br>
  <hr> <br>
  <h4 align='center'>Data Pendaftaran</h4>
  <h5  align='center'>Bulan : $bulan &nbsp;&nbsp;&nbsp;&nbsp; Tahun: $tahun</h5>
  <p align='center'>
    <table cellpadding='0' cellspacing='1' style='width: 210mm;' border=0.5>
      <tr bgcolor='#CCCCCC'>
        <th style='width: 65;'>No Daftar</th>
        <th style='width: 100;'>Tanggal Daftar</th>
        <th style='width: 110;'>Nama Pasien</th>
        <th style='width: 110;'>Nama Orang Tua</th>
        <th style='width: 60;'>JenKel</th>
        <th style='width: 120;'>Alamat</th>
        <th style='width: 100;'>No Telepon</th>
        <th style='width: 90;'>Kategori Pasien</th>
        <th style='width: 50;'>Umur</th>
        <th style='width: 50;'>Berat Badan</th>
        <th style='width: 100;'>Keluhan</th>
        <th style='width: 100;'>Keterangan</th>
        <th style='width: 100;'>Bidan</th>
        <th style='width: 120;'>Note Penyuluhan</th>
      </tr>";
      // Menampilkan data
      $query = mysql_query("SELECT c.*, b.*
                FROM pendaftaran b
                INNER JOIN kms c ON c.no_daftar = b.no_daftar
                WHERE YEAR(b.tgl_daftar)='$tahun' AND MONTH(b.tgl_daftar)='$bulan'");
      $no = 1; // nomor baris
      while ($r = mysql_fetch_array($query)) {
      $content.="<tr bgcolor='#FFFFFF'>
        <td>$no</td>
        <td>$r[no_daftar]</td>
        <td>$r[tgl_daftar]</td>
        <td style='text-transform:capitalize'>$r[nm_pasien]</td>
        <td style='text-transform:capitalize'>$r[nm_orangtua]</td>
        <td style='text-transform:capitalize'>$r[jenkel]</td>
        <td style='text-transform:capitalize'>$r[alamat]</td>
        <td style='text-align:center'>$r[no_telp]</td>
        <td style='text-transform:capitalize'>$r[kat_pasien]</td>
        <td style='text-align:center'>$r[umur]</td>
        <td style='text-align:center'>$r[berat_badan]</td>
        <td style='text-align:center'>$r[keluhan]</td>
        <td style='text-align:center'>$r[keterangan]</td>
        <td style='text-align:center'>$r[bidan]</td>
        <td style='text-align:center'>$r[note_penyuluhan]</td>
      </tr>";
      $no++;
      }
    $content.="</table></p><br><br>";

  $filename="Laporan Pasien ".date('d-m-y').".pdf"; //ubah untuk menentukan nama file pdf yang dihasilkan nantinya

  ob_end_clean();
  // conversion HTML => PDF
  try
  {
    $html2pdf = new HTML2PDF('L', 'A4','en', false, 'ISO-8859-15');
    $html2pdf->setDefaultFont('Arial');
    $html2pdf->writeHTML($content, isset($_GET['vuehtml']));
    $html2pdf->pdf->IncludeJS('print(TRUE)');
    $html2pdf->Output($filename);
  }
  catch(HTML2PDF_exception $e) { echo $e; }
?>