lap-transaksi.php

<form class="form-inline hidden-print" action="<?=$_SERVER["REQUEST_URI"]?>" method="post">
    <label>Periode</label>
    <input type="text" class="form-control" name="start">
    <label>s/d</label>
    <input type="text" class="form-control" name="stop">
    <button type="submit" class="btn btn-primary btn-sm">Tampilkan</button>
  </form>
  <br>
  <?php if ($_POST): ?>
    <div class="panel panel-info">
        <div class="panel-heading"><h3 class="text-center">LAPORAN KONFIRMASI</h3></div>
        <div class="panel-body">
            <table class="table table-condensed">
                <thead>
                    <tr>
                        <th>No</th>
                        <th>Nama</th>
                        <th>Tgl Sewa</th>
                        <th>Total Harga</th>
                        <th class="hidden-print"></th>
                    </tr>
                </thead>
                <tbody>
                    <?php $no = 1; ?>
                    <?php if ($query = $connection->query("SELECT * FROM transaksi JOIN pelanggan USING(id_pelanggan) JOIN konfirmasi USING(id_transaksi) WHERE tgl_sewa BETWEEN '$_POST[start]' AND '$_POST[stop]'")): ?>
                        <?php while($row = $query->fetch_assoc()): ?>
                        <tr>
                            <td><?=$no++?></td>
                            <td><?=$row['nama']?></td>
                            <td><?=date("d-m-Y H:i:s", strtotime($r['tgl_sewa']))?></td>
                            <td><?=$row['total_harga']?></td>
                            <td class="hidden-print">
                              <a  href="../assets/img/bukti/<?=$row['bukti']?>" class="btn btn-info btn-xs fancybox">Lihat Bukti</a>
                            </td>
                        </tr>
                        <?php endwhile ?>
                    <?php endif ?>
                </tbody>
            </table>
        </div>
        <div class="panel-footer hidden-print">
            <a onClick="window.print();return false" class="btn btn-primary"><i class="glyphicon glyphicon-print"></i></a>
        </div>
    </div>
  <?php endif; ?>

<script type="text/javascript">
$(document).ready(function(){
  $(".fancybox").fancybox({
    openEffect  : 'none',
    closeEffect : 'none',
    iframe : {
      preload: false
    }
  });
  $(".various").fancybox({
    maxWidth    : 800,
    maxHeight    : 600,
    fitToView    : false,
    width        : '70%',
    height        : '70%',
    autoSize    : false,
    closeClick    : false,
    openEffect    : 'none',
    closeEffect    : 'none'
  });
  $('.fancybox-media').fancybox({
    openEffect  : 'none',
    closeEffect : 'none',
    helpers : {
      media : {}
    }
  });
});
</script>