<?php
   include '../conn/koneksi.php';
   include 'transaksi_fungsi.php';
   ?>

   <!-- menu tengah -->
    <div id="menu-tengah">
        <div id="bg_menu">Data Transaksi
        </div>
        <div id="content_menu">
        <div id="menu_header">
            <form action="?page=transaksi_search" method="post">
            <table width="100%" height="100%" style="border:1px solid #9cc;">
                <tr>
                    <td width="50%"><a href="?page=data_hilang"/><input name="" type="button" value="Data Hilang" /></a><a href="?page=data_kembali"/><input name="" type="button" value="Data Kembali" /></a></td>
                    <td width="50%" align="right"><input type="text" name="cari" size="30" placeholder="Nama Peminjam"></td>
                    <td><input type="submit" id="submit" value="cari"></td>
                </tr>

            </table>
            </form>

        </div>
        <div class="zebra-table">

          <table width="100%" height="100%" align="center" cellspacing="0" cellpadding="5">
            <thead align="center">
              <tr>
                <th align="center" width="5%" >No</th>
                <th>Kode</th>
                <th>Judul Buku</th>
                <th>Peminjam</th>
                <th>Tgl Pinjam</th>
                <th>Tgl Kembali</th>
                <th>Terlambat</th>
                <th>Denda</th>
                <th colspan="3">Action</th>
                </tr>
            </thead>

            <?php

                $query = "SELECT * FROM tbl_transaksi WHERE status='Pinjam' ORDER by id";
                $sql = mysql_query($query);
                $total = mysql_num_rows($sql);
                $no = 1;

                while ($data=mysql_fetch_array($sql)) {
            ?>


            <tbody><form  action="?page=transaksi_proses_kembali&id=<?php echo $data['id']; ?>&judul=<?php echo $data['judul']; ?>" method="post">
              <tr>
                <td align="center"><?php echo $no; ?><input name="id" type="text" size="5" value="<?php echo $data['id']; ?>" /></td>
                <td align="center"><?php echo $data['kd_transaksi']; ?></td>
                <td align="center"><?php echo $data['judul']; ?></a></td>
                <td align="center"><?php echo $data['nama']; ?></td>
                <td align="center"><?php echo $data['tgl_pinjam']; ?></td>
                <td align="center"><?php echo $data['tgl_kembali']; ?></td>
                <td align="center">
                <?php
                    $tgl_dateline=$data['tgl_kembali'];
                    $tgl_kembali=date('d-m-Y');
                    $lambat=terlambat($tgl_dateline, $tgl_kembali);
                    $denda=$lambat*$denda1;
                    if ($lambat>0) {
                        echo "$lambat hari";
                    }
                    else {
                        echo "-";
                    }
                ?>

                </td>

                <td><input name="denda" type="text" value="<?php echo $denda ?>" size="5" readonly="readonly"/></td>
                <td align="center"><input name="submit1" value="K" type="submit" /></td>
                <td align="center"><a href="?page=transaksi_proses_perpanjang&id=<?php echo $data['id']; ?>&judul=<?php echo $data['judul'];?>&tgl_kembali=<?php echo $data['tgl_kembali']; ?>&lambat=<?php echo $lambat; ?>"><input name="" type="button" value="P" /></a></td>
                <td align="center"><input name="submit2" type="submit" value="H" />

               </td>
              </tr>
            <?php $no++; } ?>
            </form>
            </tbody>
          </table>
          </div>
          <div id="menu_bottom">
            <table width="100%" style="border:0px solid #9cc;">
                <tr>
                    <td width="30%">Jumlah : <?php echo $total; ?> Transaksi</td>

                    <td width="60%" align="right"><a href="?page=tgl-print"><img src="../images/print.jpg" width="50px" height="50px" title="Print Data"/></a>

                    <td align="right"><a href="?page=transaksi_kode"><img src="../images/ICON/simpan.png" width="50px" height="50px" title="Input Transaksi"/></a></td>
</tr>
            </table>
        </div>
      </div>
    </div>