<?php
ob_start();
include_once('../../../config/db.php');
session_start();
if (!isset($_SESSION['username'])){
header ("location:../../login/login.php");
}
if ($_SESSION['level']!="Admin"){

    echo "<script>alert('Anda Tidak Dapat Mengakses Halaman Ini');window.location = 'not_found.php'</script>";
}
?>

<h3 style="text-align: center;"> LAPORAN SELURUH METADATA PROVINSI BALI </h3>
<table class="table table-bordered" border="1">
          <tbody>
    <tr>
      <th width="24" rowspan="2" scope="col" style="line-height: 50px;">NO</th>
      <th width="64" rowspan="2" scope="col" text-align="center" style="line-height: 30px;">ID Database</th>
      <th width="44" rowspan="2" scope="col" style="line-height: 90px;">Nama Pos</th>
      <th width="39" rowspan="2" scope="col" style="line-height: 30px;">Jenis Pos</th>
      <th width="52" rowspan="2" scope="col" style="line-height: 30px;">No.Pos Lama</th>
      <th width="52" rowspan="2" scope="col" style="line-height: 30px;">No.Pos Baru</th>
      <th colspan="2" scope="col" style="text-align: center;">Kordinat</th>
      <th width="57" rowspan="2" scope="col" style="line-height: 30px;">Elevasi (mdpl)</th>
      <th colspan="4" scope="col" style="text-align: center;">Lokasi Alat Terpasang</th>
      <th width="71" rowspan="2" scope="col" style="line-height: 30px;">Tahun Alat Dipasang/Rehab</th>
      <th width="55" rowspan="2" scope="col" style="line-height: 30px;">Kondisi Alat</th>
      <th width="89" rowspan="2" scope="col" style="line-height: 30px;">Kepemilikan Alat</th>
      <th colspan="2" scope="col" style="text-align: center;">Pengelola</th>
      <th width="129" rowspan="2" scope="col" style="line-height: 30px;">Pengiriman Data</th>
      <th width="130" rowspan="2" scope="col" style="line-height: 30px;">Ketersediaan Data Di BMKGSoft</th>
      <th width="130" rowspan="2" scope="col" style="line-height: 30px;">Keterangan</th>
    </tr>
    <tr>
      <th width="48">Lintang(°) </th>
      <th width="33">Bujur(°) </th>
      <th width="97" style="text-align: center;">Desa/Kelurahan</th>
      <th width="69" style="text-align: center;">Kecamatan</th>
      <th width="75" style="text-align: center;">Kabupaten/Kota</th>
      <th width="48" style="text-align: center;">Provinsi</th>
      <th width="37" style="text-align: center;">Nama Pengamat</th>
      <th width="58" style="text-align: center;">Alamat Pengelola</th>
    </tr>
  </tbody>

          <?php
            include "../../config/db.php" ;
            $sql = mysql_query("SELECT * FROM bali");
            while ($tampil = mysql_fetch_array($sql)) {
             ?>
                <tr>
                  <td><?php echo  $tampil['no']; ?></td>
                  <td><?php echo  $tampil['id_database']; ?></td>
                  <td><?php echo  $tampil['nama_pos']; ?></td>
                  <td><?php echo  $tampil['jenis_pos']; ?></td>
                  <td><?php echo  $tampil['no_pos_lama']; ?></td>
                  <td><?php echo  $tampil['no_pos_baru']; ?></td>
                  <td><?php echo  $tampil['lintang']; ?></td>
                  <td><?php echo  $tampil['bujur']; ?></td>
                  <td><?php echo  $tampil['elevasi']; ?></td>
                  <td><?php echo  $tampil['desa']; ?></td>
                  <td><?php echo  $tampil['kecamatan']; ?></td>
                  <td><?php echo  $tampil['kabupaten']; ?></td>
                  <td><?php echo  $tampil['provinsi']; ?></td>
                  <td><?php echo  $tampil['tahun_dipasang']; ?></td>
                  <td><?php echo  $tampil['kondisi_alat']; ?></td>
                  <td><?php echo  $tampil['kepemilikan_alat']; ?></td>
                  <td><?php echo  $tampil['nama']; ?></td>
                  <td><?php echo  $tampil['alamat_pengelola']; ?></td>
                  <td><?php echo  $tampil['pengiriman_data']; ?></td>
                  <td><?php echo  $tampil['ketersediaan_data']; ?></td>
                  <td><?php echo  $tampil['keterangan']; ?></td>
                </tr>
             <?php
            }
          ?>
        </table>


<?php
$out = ob_get_contents();
ob_end_clean();
include '../../../mpdf60/mpdf.php';
$mpdf = new mPDF('c','A4-L','');
$mpdf->SetDisplayMode('fullpage');
$stylesheet = file_get_contents('../../../mpdf60/mpdf.css');
$mpdf->WriteHTML($stylesheet,1);
$mpdf->WriteHTML($out);
$mpdf->Output('Bali', 'I');
  exit;
?>