<!-- 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
