<?php
include'../library/config.php';
include'../content/function.php';
$pl =query("SELECT * FROM project_list INNER JOIN status ON status.id_status = project_list.id_status ORDER BY project_list.id_projek DESC");
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=report.xls");

?>
<style type="text/css">
   img,
   table,
   tr,
   td
   {
      vertical-align: center;
   }
   .re
   {
      font-size:30px;
   }
   .duk
   {
      font-size:18px;
   }
   .si
   {
      text-align:left;
   }
   h1{
      text-align: center;
   }
</style>
<center>
   <div class="re">LAPORAN DATA BARANG</div>
   <div class="duk">PT SUPERNOVA FLEXIBLE PACKAGING</div>
   <div class="duk">MANUFACTURING & CONVERTING OF SPECIALITY FLEXIBLE PACKAGING</div>
   <div class="si">Tanggal : <?php echo Date('d F Y');?></div>
</center>

<h1>REKAP DATA BARANG</h1>


<table class="table table-striped table-hover table-bordered table-responsive" border="2px">
      <thead>
         <tr>
                  <th>NO.</th>
                  <th>Area / Mesin</th>
                  <th>Judul Projek</th>
                  <th>Uraian Progress</th>
                  <th>Nomor WO</th>
                  <th>Nomor PR</th>
                  <th>Tanggal Mulai</th>
                  <th>Tanggal Selesai</th>
                  <th>Status</th>
         </tr>
      </thead>
      <tbody>

         <?php $i = 1; ?>
         <?php foreach ( $pl as $data ) : ?>
      <tr>
         <td><?= $i ?></td>
                  <td><?= $data['area_mesin'] ?></td>
                  <td><?= $data['judul_projek'] ?></td>
                  <td><?= $data['uraian_progress'] ?></td>
                  <td><?= $data['nomor_wo'] ?></td>
                  <td><?= $data['nomor_pr'] ?></td>
                  <td><?= $data['tanggal_mulai'] ?></td>
                  <td><?= $data['tanggal_selesai'] ?></td>
                  <td><?= $data['nama_status'] ?></td>
                  <td>
     </tr>
         <?php $i++; ?>
         <?php endforeach; ?>
   </tbody>
</table>






















<style type="text/css">
   img,
   table,
   tr,
   td
   {
      vertical-align: center;
   }
   .re
   {
      font-size:30px;
   }
   .duk
   {
      font-size:18px;
   }
   .si
   {
      text-align:left;
   }
   h1{
      text-align: center;
   }
</style>
<center>
 <div class="duk">Office & Factory :</div>
 <div class="duk">Jl. Industri Selatan Blok LL No.1 Jababeka II, Cikarang, Bekasi 17550 - Indonesia</div>
 <div class="duk">Phone : (62-21)989 31969 (Hunting ) Fax : (62-21) 898 31967</div>
</center>