<td>Pengarang</td><td>:</td><td><?php echo $buku->getPengarang(); ?> </td> </tr> <tr> <td>Di Pinjam</td><td>:</td><td><?php echo $buku->getCount(); ?> </td> </tr> </table> <h4>Periode</h4> <div class="well"> <?php echo "<b>" . sekarang() . "</b> Sampai <b>" . $kembali . "</b>"; ?> </div> <?php if ($siswa_ada) { ?> <script type="text/javascript"> $('#tmbl-pinjam').focus(); $('#tmbl-pinjam').click(function(){ $.ajax({ url:'ajax/ajax-pinjam.php?mode=pinjam&buku=<?php echo $_GET["buku"]; ?> &siswa=<?php echo $siswa->getInduk(); ?>
if ($_GET['bulan'] == '11') { echo "selected='selected'"; } ?> >Nopember</option> <option value="12" <?php if ($_GET['bulan'] == '12') { echo "selected='selected'"; } ?> >Desember</option> </select> <select name='tahun' onchange='kirim()' style="width: 100px"> <option value=''>Tahun</option> <?php $sekarang = substr(sekarang(), -4); for ($i = 2011; $i <= $sekarang; $i++) { $select = ''; if (!isset($_GET['tahun'])) { if ($i == $sekarang) { $select = ''; //"selected='selected'"; } } else { $tahu = $_GET['tahun']; if ($i == $tahu) { $select = 'selected="selected"'; } } echo "<option value='{$i}' {$select}>{$i}</option> "; }
} ?> </table><!--Tabel anak--> </div> <div class="tab-pane" id="tab4"> <!--jatuh tempo--> <table class="table table-striped table-hover" width='100%' style='font-size: 12px; border: 1px inset;' cellspacing='1' cellpadding='2'> <thead> <tr align='center' style="font-weight: bold;"> <td>No</td><td>Kode Buku</td><td>Judul Buku</td><td>Peminjam</td><td width="100px">Tanggal</td> </tr> </thead> <?php $jatuh = new db(); $saiki = sekarang(); $jatuh->sql("SELECT * FROM tbl_telat"); $jum = $jatuh->getJml(); if ($jum != '0') { $noer = 1; while ($jatuh->hasil()) { echo "<tr id='pop' title='Kode Buku " . $jatuh->hasil['buku'] . "'>"; echo "<td>{$noer}</td>"; echo "<td>" . $jatuh->hasil['buku'] . "</td>"; echo "<td>" . $jatuh->hasil['judul'] . "</td>"; echo "<td><a href='peminjaman.php?pencarian=" . $jatuh->hasil['induk'] . "'>" . $jatuh->hasil['siswa'] . "</a></td>"; echo "<td>" . date('d M Y', strtotime($jatuh->hasil['tanggal'])) . "</td>"; echo "</tr>"; $noer++; } } else {
$obuku->setKode($buku); $osiswa->setInduk($siswa); $s = mysql_query("DELETE FROM tbl_telat WHERE buku='{$buku}'"); if ($s) { //echo "hapused"; } else { catat("Gagal Menghapus Jatuh Tempo " . $obuku->getJudul() . " " . $osiswa->getNama()); } catat($_SESSION['nama'], "Mengembalikan Buku " . $obuku->getJudul() . " dari " . $osiswa->getNama()); } exit(0); } //Jika fungsi mengembalikan semua if ($_GET["kembali"] == "all") { //inisialisasi data $kembaline = sekarang(); $siswa = $_GET["siswa"]; $osiswa = new siswa(); $osiswa->setInduk($siswa); $kmb = mysql_query("UPDATE tbl_peminjaman SET kembali='1', tgl_kembali='{$kembaline}' WHERE siswa='{$siswa}' && kembali='0'"); $buk = mysql_query("UPDATE tbl_buku SET status='1', peminjam='0' WHERE peminjam='{$siswa}'"); //echo "UPDATE pinjaman SET kembali='1', kembaline='$kembaline' WHERE siswa='$siswa' && kembali='0' <br>"; //echo "update buku set status='Ada', peminjam='0' where peminjam='$siswa' <br>"; //$tempo= if ($kmb && $buk) { $c = mysql_query("DELETE FROM tbl_telat WHERE induk ='{$siswa}'"); if ($c) { //echo "Di Busek"; } else { catat("Gagal Menghapus Jatuh Tempo dari " . $osiswa->getNama()); }
<?php session_start(); require 'sistem/config.php'; require 'sistem/class_buku.php'; sambung(); for ($i = 1; $i <= 120; $i++) { $tglK = sekarang(tgl) - $i; /*Tanggal*/ $hari = date('d'); $bulan = date('M'); $tahun = date('Y'); $indo = array('Januari', 'Pebruari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'Nopember', 'Desember'); $bln = $indo[$bulan + 1]; $hari_ini = sekarang(); //"$hari $bln $tahun"; //**tgl kembali**// $waktu = date("d-n-Y", mktime(0, 0, 0, date("m"), date("d") + $tglK, date("Y"))); $x = explode('-', $waktu); $hari2 = $x['0']; $bulan2 = $x['1']; $tahun2 = date('Y'); $bln2 = $indo[$bulan2 - 1]; //**waktu kembali yg sudah fix**// $kembali = "{$hari2} {$bln2} {$tahun2}"; //run $kemarin = $waktu = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") + $tglK, date("Y"))); //echo $kemarin."<br>"; $temSql = mysql_query("SELECT * FROM tbl_peminjaman WHERE kembali='0' AND tgl_tempo='{$kemarin}'"); $count = 0; if ($tglK < 0) {
<li><a href='#' onclick='window.location="log.php"' title='Lihat Catatan Log / Aktivitas Pengguna'><i class="icon-list-alt"></i> Aktivitas</a></li> <li><a href='#' onclick='window.location="kas.php"' title='Lihat Catatan Kas'><i class="icon-shopping-cart"></i> Catatan Kas</a></li> <li><a href='#' onclick='window.location="anggota.php"' title='Lihat Data Siswa'><i class="icon-user"></i> Anggota</a></li> <li><a href='#' onclick='window.location="backup.php"' title='Backup Restore Database'><i class="icon-hdd"></i> Database</a></li> <li><a href='#' onclick='window.location="atur.php"' title='Pengaturan'><i class=" icon-wrench"></i> Pengaturan</a></li> </ul> </li> <li class="divider-vertical"></li> </ul> <form class="navbar-form pull-left" action="buku.php" method="get"> <input type="text" class="span2" name="pencarian" placeholder="Cari kode buku" > <button type="submit" class="btn">Cari</button> </form> <ul class="nav pull-right"> <li style="padding: 10px; font-weight: bold;"><?php echo sekarang(); ?> </li> <li class="divider-vertical"></li> <li class="dropdown"> <a class="dropdown-toggle" id="dLabel" role="button" data-toggle="dropdown" data-target="#" href="/page.html"> <i class='icon-user'></i> <?php echo $_SESSION['nama']; ?> <b class="caret"></b> </a> <ul class="dropdown-menu" role="menu" aria-labelledby="dLabel"> <li><a href="keluar.php" title='Keluar Aplikasi' >Keluar</a></li> <li><a tabindex="-1" data-toggle="modal" data-target="#pustakawan" href="ajax/ajax-pustakawan.php?mode=ubah&uid=<?php echo $_SESSION['uid']; ?>
</tr> <tr> <td>Peminjaman</td> <td>:</td> <td><b><script type='text/javascript'>document.write(format(<?php $blne = explode(" ", sekarang()); $thne = $blne['2']; echo $peminjam->baris("SELECT * FROM tbl_peminjaman WHERE tgl_pinjam like '{$thne}%'"); ?> ));</script></b></td> </tr> <tr> <td>Pengembalian</td> <td>:</td> <td><b><script type='text/javascript'>document.write(format(<?php $blne = explode(" ", sekarang()); $thne = $blne['2']; echo $peminjam->baris("SELECT * FROM tbl_peminjaman WHERE tgl_kembali LIKE '{$thne}%'"); ?> ));</script></b></td> </tr> </table> </td><!--Tabel Kolom Kiri1--> </tr> </table> <br><br> <i class="icon-file"></i> <b>Download (Format *.xls):</b><br><br> <form action='halaman/exs.php' method='get'> <select name='tabel' onchange='submiter.disabled=false'> <option value='none' selected='selected'>Pilih Tabel</option> <option value='tbl_buku'>Buku</option>