<!-- Komentar Anda --> <div class="panel panel-primary"> <div class="panel-heading"><i class="fa fa-wechat"></i> Komentar Anda</div> <div class="panel-body"> <div class="container-fluid"> <marquee direction="up" scrollamount="4"> <?php $query_chat = mysql_query("SELECT * FROM t_chat order by id"); while ($data_chat = mysql_fetch_array($query_chat)) { ?> <div class="panel panel-success"> <div class="panel-body"> <?php echo '<p style="font-size:14px;"><strong><i class="fa fa-male"></i> ' . ucwords($data_chat['nama']) . '</strong></p> <p style="font-size:10px;"><i class="fa fa-calendar"></i> ' . tgl_db($data_chat['tgl']) . ' ' . jam_db($data_chat['tgl']) . '</p> <p style="font-size:12px;"><i class="fa fa-comment"></i> ' . $data_chat['chat'] . '</p>'; ?> </div> </div> <?php } ?> </marquee> </div> </div> <div class="panel-footer"> <?php include "controller/chat.php"; ?>
{ $query = mysql_query("SELECT * FROM t_peminjaman JOIN det_pinjam ON t_peminjaman.kd_pinjam = det_pinjam.kd_pinjam \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE t_peminjaman.kd_pinjam = '{$param}'"); $count = mysql_num_rows($query); return $count . " Buku"; } include "../../utiliti/tgl_db.php"; $no = 1; while ($fetch_tampil = mysql_fetch_array($query_tampil)) { ?> <tr> <td width="20"><?php echo $no++; ?> </td> <td width="50"><?php echo tgl_db($fetch_tampil['tgl_pinjam']); ?> </td> <td><?php echo $fetch_tampil['kd_pinjam']; ?> </td> <td><?php echo $fetch_tampil['id_anggota']; ?> </td> <td><?php echo $fetch_tampil['nama']; ?> </td> <td><?php
</td> </tr> <tr> <td width="30">Id Anggota</td> <td width="5">:</td> <td width="80"><?php echo $fetch_tampil['id_anggota']; ?> </td> <td width="3"></td> <td width="30">Tanggal Harus Kembali</td> <td width="5">:</td> <td width="80"><?php echo tgl_db($fetch_tampil['tgl_hrskembali']); ?> </td> </tr> <tr> <td width="30">Nama Anggota</td> <td width="5">:</td> <td width="80"><?php echo $fetch_tampil['nama']; ?> </td> <td width="3"></td> <td width="30">Tempo Peminjaman</td> <td width="5">:</td>
</tr> <tr> <td width="30"><b>Judul Artikel</b></td> <td width="10">:</td> <td width="200"><?php echo $fetch_det['judul']; ?> </td> </tr> <tr> <td width="30"><b>Tanggal Publish</b></td> <td width="10">:</td> <td width="200"> <?php include "../utiliti/tgl_db.php"; echo tgl_db($fetch_det['tgl_publish']); ?> </td> </tr> <tr> <td width="30"><b>Jam</b></td> <td width="10">:</td> <td width="200"> <?php include "../utiliti/jam_db.php"; echo jam_db($fetch_det['tgl_publish']); ?> </td> </tr> <tr> <td width="30"><b>Deskripsi</b></td>
</tr> <tr> <td width="30"><b>Kategori</b></td> <td width="10">:</td> <td width="200"><?php echo $fetch_det['kategori']; ?> </td> </tr> <tr> <td width="30"><b>Tanggal Perolehan</b></td> <td width="10">:</td> <td width="200"> <?php include "../utiliti/tgl_db.php"; echo tgl_db($fetch_det['tgl_perolehan']); ?> </td> </tr> <tr> <td width="30"><b>DDC</b></td> <td width="10">:</td> <td width="200"><?php echo $fetch_det['ddc']; ?> </td> </tr> <tr> <td width="30"><b>RAK</b></td> <td width="10">:</td> <td width="200"><?php
$tgl1 = isset($_GET['awal']) ? $_GET['awal'] : null; $tgl2 = isset($_GET['akhir']) ? $_GET['akhir'] : null; $judul = "<strong><h3>Laporan Data Transaksi Peminjaman Per Periode " . tgl_db($tgl1) . " s/d " . tgl_db($tgl2) . "</h3></strong>\n\t\t\t <p>Sistem Informasi perpustakaan AMIK YMI Tegal</p>"; $header = "<table>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>No </th>\n\t\t\t\t\t<th>Tanggal Peminjaman</th>\n\t\t\t\t\t<th>Kode Pinjam</th>\n\t\t\t\t\t<th>ID Anggota</th>\n\t\t\t\t\t<th>Nama</th>\n\t\t\t\t\t<th>Jumlah Pinjam</th>\n\t\t\t\t</tr>"; $query_tampil = mysql_query("SELECT * FROM t_peminjaman JOIN t_anggota ON t_peminjaman.id_anggota = t_anggota.id_anggota\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE tgl_pinjam BETWEEN '{$tgl1}' AND '{$tgl2}'"); //mencari jumlah buku function jum_buk($param) { $query = mysql_query("SELECT * FROM t_peminjaman JOIN det_pinjam ON t_peminjaman.kd_pinjam = det_pinjam.kd_pinjam \n\t\t\t\t\t\t\t WHERE t_peminjaman.kd_pinjam = '{$param}'"); $count = mysql_num_rows($query); return $count . " Buku"; } $content_dalam = ""; $no = 1; while ($fetch_data = mysql_fetch_array($query_tampil)) { $content = "<tr>\n\t\t\t\t\t\t<td>" . $no++ . "</td>\n\t\t\t\t\t\t<td>" . tgl_db($fetch_data['tgl_pinjam']) . "</td>\n\t\t\t\t\t\t<td>" . $fetch_data['kd_pinjam'] . "</td>\n\t\t\t\t\t\t<td>" . $fetch_data['id_anggota'] . "</td>\n\t\t\t\t\t\t<td>" . $fetch_data['nama'] . "</td>\n\t\t\t\t\t\t<td>" . jum_buk($fetch_data['kd_pinjam']) . "</td>\n\t\t\t\t\t</tr>"; $content_dalam = $content_dalam . "" . $content; } $footer = "</table>"; $print_sheet = $judul . "<br>" . $header . "\n" . $content_dalam . "\n" . $footer; $tgl_sekarang = date("Ymd"); header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=" . $tgl_sekarang . "Lap_peminjaman.xls"); header("Pragma: no-cache"); header("Expires : 0"); print $print_sheet; ?> <script> self.close();
?> </td> <td><?php echo $fetch_tampil['pengarang']; ?> </td> <td><?php echo $fetch_tampil['tahun']; ?> </td> <td><?php echo $fetch_tampil['isbn']; ?> </td> <td><?php echo tgl_db($fetch_tampil['tgl_perolehan']); ?> </td> </tr> <?php } ?> </table> <?php } ?> </div> </div> </div> <!-- end panel default -->
$tanggal_sekarang = date("Y-m-d"); ?> <input type="text" readonly name="tgl_pinjam" value="<?php echo tgl_db($tanggal_sekarang); ?> " class="form-control"> </div> </div> <div class="form-group"> <label for="" class="col-sm-4 control-label">Tgl Harus kembali </label> <div class="col-sm-4"> <?php $seminggu = date("Y-m-d", strtotime('+7 day')); ?> <input type="text" readonly value="<?php echo tgl_db($seminggu); ?> " class="form-control"> </div> </div> <div class="form-group"> <label for="" class="col-sm-4 control-label">Keterangan</label> <div class="col-sm-4"> <textarea name="ket" id="" cols="22" rows="1"><?php echo $_POST['ket']; ?> </textarea> </div> </div> </div> <!-- end col 6 2 --> </div> <!-- ecn row -->
</td> </tr> <tr> <td width="70">Tahun Terbit</td> <td>:</td> <td><?php echo $data['tahun']; ?> </td> </tr> <tr> <td width="70">Tanggal Perolehan</td> <td>:</td> <td><?php include "../utiliti/tgl_db.php"; echo tgl_db($data['tgl_perolehan']); ?> </td> </tr> <tr> <td width="70">Jumlah Buku</td> <td>:</td> <td><?php echo $data['jumlah_buku']; ?> </td> </tr> <tr> <td width="70">ISBN</td> <td>:</td> <td><?php
<?php error_reporting(E_ALL ^ E_NOTICE); include "utiliti/koneksi.php"; $id = isset($_GET['id']) ? $_GET['id'] : null; $query = mysql_query("SELECT * FROM t_info WHERE id = '{$id}'"); $fecth = mysql_fetch_array($query); ?> <div class="panel panel-primary"> <div class="panel-body"> <h3><i class="fa fa-bullhorn"></i> <?php echo $fecth['judul']; ?> </h3> <p style="font-size:11px"><i class="fa fa-calendar"></i> <?php echo tgl_db($fecth['tgl_publish']) . " " . jam_db($fecth['tgl_publish']); ?> </p> <?php echo $fecth['deskripsi']; ?> </div> </div>
$query = mysql_query("Select * from t_info where label='lain'"); while ($fetch = mysql_fetch_array($query)) { ?> <tr> <td><?php echo $no++; ?> </td> <td><?php echo $fetch['judul']; ?> </td> <td> <?php include "../utiliti/tgl_db.php"; echo tgl_db($fetch['tgl_publish']); ?> </td> <td> <a href="?module=info&page=lain&ref=det_lain&id=<?php echo $fetch[0]; ?> " class="btn btn-default btn-flat"><i class="fa fa-search"></i></a> <a href="?module=info&page=lain&ref=edit_lain&id=<?php echo $fetch[0]; ?> " class="btn btn-primary btn-flat"><i class="fa fa-edit"></i></a> <a href="?module=info&page=lain&ref=hapus_lain&id=<?php echo $fetch[0]; ?> " class="btn btn-danger btn-flat"><i class="fa fa-trash"></i></a>
<?php error_reporting(E_ALL ^ E_NOTICE); include "../../../utiliti/koneksi.php"; include "../../../utiliti/tgl_db.php"; $tgl1 = isset($_GET['awal']) ? $_GET['awal'] : null; $tgl2 = isset($_GET['akhir']) ? $_GET['akhir'] : null; $judul = "<strong><h3>Laporan Data Anggota Terdaftar Periode " . tgl_db($tgl1) . " s/d " . tgl_db($tgl2) . "</h3></strong>\n\t\t\t <p>Sistem Informasi perpustakaan AMIK YMI Tegal</p>"; $header = "<table>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>ID Anggota</th>\n\t\t\t\t\t<th>NIM</th>\n\t\t\t\t\t<th>Nama</th>\n\t\t\t\t\t<th>Email</th>\n\t\t\t\t\t<th>Tanggal Terdaftar</th>\n\t\t\t\t</tr>"; $query_tampil = mysql_query("SELECT * FROM t_anggota WHERE tanggal BETWEEN '{$tgl1}' AND '{$tgl2}'"); $content_dalam = ""; while ($fetch_data = mysql_fetch_array($query_tampil)) { $content = "<tr>\n\t\t\t\t\t\t<td>" . $fetch_data['id_anggota'] . "</td>\n\t\t\t\t\t\t<td width='300'>" . $fetch_data['nim'] . "</td>\n\t\t\t\t\t\t<td width='100'>" . $fetch_data['nama'] . "</td>\n\t\t\t\t\t\t<td width='100'>" . $fetch_data['email'] . "</td>\n\t\t\t\t\t\t<td>" . tgl_db($fetch_data['tanggal']) . "</td>\n\t\t\t\t\t</tr>"; $content_dalam = $content_dalam . "" . $content; } $footer = "</table>"; $print_sheet = $judul . "<br>" . $header . "\n" . $content_dalam . "\n" . $footer; $tgl_sekarang = date("Ymd"); header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=" . $tgl_sekarang . "Lap_anggota.xls"); header("Pragma: no-cache"); header("Expires : 0"); print $print_sheet; ?> <script> self.close(); </script>
<tr> <td width="30">Nama Peminjam</td> <td width="5">:</td> <td width="80"><input type="text" readonly="" class="form-control" value="<?php echo $fetch_tampil['nama']; ?> "></td> <td width="3"></td> <td width="30">Tanggal kembali</td> <td width="5">:</td> <td width="80"> <?php $tgl_sekarang = date("Y-m-d"); echo '<input type="text" readonly name="tgl_sekarang" class="form-control" value="' . tgl_db($tgl_sekarang) . '">'; ?> </td> </tr> <tr> <td width="30"></td> <td width="5"></td> <td width="80"></td> <td width="3"></td> <td width="30">Telat Pengembalian</td> <td width="5">:</td> <td width="80"> <?php #deklarasi pecahan tgl harus kembali
$jumlah_record = mysql_query("SELECT COUNT(*) from t_info WHERE label='pengumuman'"); $jum = mysql_result($jumlah_record, 0); $halaman = ceil($jum / $per_hal); $page = isset($_GET['halaman']) ? (int) $_GET['halaman'] : 1; $start = ($page - 1) * $per_hal; $query_pengumuman = mysql_query("SELECT * FROM t_info WHERE label='pengumuman' ORDER BY tgl_publish DESC LIMIT {$start}, {$per_hal}"); while ($data_pengumuman = mysql_fetch_array($query_pengumuman)) { ?> <div class="panel panel-primary"> <div class="panel-body"> <h4><i class="fa fa-bullhorn"></i> <?php echo $data_pengumuman['judul']; ?> </h4> <p style="font-size:10px"> <i class="fa fa-calendar"></i> <?php echo tgl_db($data_pengumuman['tgl_publish']) . " " . jam_db($data_pengumuman['tgl_publish']); ?> </p> <?php echo $data_pengumuman['deskripsi']; ?> </div> </div> <?php } ?> <ul class="pagination"> <li> <a href="?page=pengumuman&halaman=<?php echo $page - 1; ?>
<td><?php echo $fetch_tampil['id_anggota']; ?> </td> <td><?php echo $fetch_tampil['nim']; ?> </td> <td><?php echo $fetch_tampil['nama']; ?> </td> <td><?php echo $fetch_tampil['email']; ?> </td> <td><?php echo tgl_db($fetch_tampil['tanggal']); ?> </td> </tr> <?php } ?> </table> <button type="button" class="btn btn-success" onclick="window.print()"> <span class="glyphicon glyphicon-print"></span> Cetak Dokumen </button> </center> </div> </body> </html>
?> <tr> <td><?php echo $no++; ?> </td> <td><?php echo $data['judul']; ?> </td> <td><?php echo $data['deskripsi']; ?> </td> <td><?php echo tgl_db($data['tgl_publish']); ?> </td> <td> <a href="?module=info&page=pengumuman&ref=edit_pengumuman&id=<?php echo $data[0]; ?> " class="btn btn-primary btn-flat"><i class="fa fa-edit"></i> Edit Pengumuman</a> <a onclick="return confirm('Hapus data ini ?')" href="?module=info&page=pengumuman&ref=hapus_pengumuman&id=<?php echo $data[0]; ?> " class="btn btn-danger btn-flat"><i class="fa fa-trash"></i> Hapus</a> </td> </tr> <?php }
</td> <td><?php echo $data['email']; ?> </td> <td><?php echo $data['telp']; ?> </td> <td><?php echo $data['alamat']; ?> </td> <td> <?php echo tgl_db($data['tanggal']); ?> </td> <td> <a href="?module=anggota&ref=edit_anggota&id=<?php echo $data[0]; ?> " class="btn btn-primary btn-flat" title="Edit Data"><i class="fa fa-edit"></i> Edit</a> <a onclick="return confirm('Hapus Data Ini ??')" href="?module=anggota&ref=hapus_anggota&id=<?php echo $data[0]; ?> " class="btn btn-danger btn-flat" title="Hapus Data"><i class="fa fa-trash"></i> Hapus</a> <?php if ($data['aktif'] == "N") { ?> <a href="?module=anggota&ref=aktivasi&id=<?php