$cid = 0;
}
$mtipe = gpost('mtipe');
if ($mtipe == '') {
$mtipe = 0;
}
$fmod = 'peminjaman_buku';
$xtable = new xtable($fmod, 'Item');
$xtable->optw = '50px';
// Query
$db = new xdb("pus_peminjaman");
$db->field('pus_peminjaman:*', 'pus_buku:callnumber,barkode', 'pus_katalog:judul');
$db->join('buku', 'pus_buku');
$db->joinother('pus_buku', 'katalog', 'pus_katalog', 'replid');
$db->where("pus_peminjaman.member='{$cid}' AND pus_peminjaman.mtipe='{$mtipe}'");
$db->order("pus_peminjaman.status DESC");
//echo $db->getsql();
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
//$xtable->btnbar_begin();
// echo '<button class="btn" title="Tambah item" onclick="'.$fmod.'_form(\'af\')"><div class="bi_add">Item</div></button>';
//$xtable->btnbar_end();
echo '<div style="float:none !important">';
if ($xtable->ndata > 0) {
// Table head
$xtable->head('barkode', 'Callnumber', 'Judul', 'status', 'Dikembalikan Tgl');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
//$xtable->td('<button class="btn" onclick="peminjaman_baliktabelpinjam('.$r['barang'].')" title="Hapus dari daftar barang yang dipinjam."><div class="bi_canb"> </div></button>',30,'c');
$xtable->td($r['barkode'], 100);
$xtable->td($r['callnumber'], 120);
$rekpasiva = array();
if (mysql_num_rows($t0) > 0) {
while ($jd = mysql_fetch_array($t0)) {
$rek = $jd['rek'];
$kategorirek = $jd['kategorirek'];
$neracasaldo[$rek] = array('debet' => 0, 'kredit' => 0, 'kode' => $jd['koderek'], 'nama' => $jd['nrek'], 'kategorirek' => $kategorirek);
$db = new xdb("keu_jurnal");
$db->field("keu_jurnal:*", "keu_rekening:kode as koderek,nama as nrek", "keu_transaksi:tanggal");
$db->join("transaksi", "keu_transaksi");
$db->join("rek", "keu_rekening");
$db->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'");
$db->where_and("keu_jurnal.rek='{$rek}'");
$db->where_and("keu_transaksi.tanggal >= '{$tanggal1}'");
$db->where_and("keu_transaksi.tanggal <= '{$tanggal2}'");
$db->where_and($fct == "" ? "" : "(" . $fct . ")");
$db->order("keu_transaksi.tanggal,keu_transaksi.nomer");
$t = $db->query();
if ($xtable->ndata > 0) {
$debet = 0;
$kredit = 0;
while ($r = mysql_fetch_array($t)) {
$debet += $r['debet'];
$kredit += $r['kredit'];
}
$selisih = $debet - $kredit;
$selisih = $selisih < 0 ? -$selisih : $selisih;
if ($debet >= $kredit) {
$neracasaldo[$rek]['debet'] = $selisih;
} else {
$neracasaldo[$rek]['kredit'] = $selisih;
}
$PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('kelas', $kls);
echo '<div class="warnbox" style="float:left">Tidak ada kelas yang diajar.</div>';
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
// Query
$db = new xdb("aka_jurnal");
$db->where_and("aka_jurnal.guru='{$gid}'");
$db->where_and("aka_jurnal.pelajaran='{$pel}'");
$db->where_and("aka_jurnal.kelas='{$kls}'");
$db->order("aka_jurnal.tanggal");
$t = $db->query();
$xtable->ndata_db($t);
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Tanggal', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['tanggal'], 200);
$xtable->td(trim_textw($r['keterangan'], 500));
$xtable->opt($r['replid'], 'u', 'd');
$xtable->row_end();
}
$xtable->foot();
} else {
echo $nophoto;
}
} else {
echo $nophoto;
}
} else {
echo $nophoto;
}
echo '</div></div>';
}
$keyw=gets('keyword');
$db=new xdb("pus_katalog");
$db->field("pus_katalog:replid,judul","pus_pengarang:nama as npengarang");
$db->join("pengarang","pus_pengarang");
$db->order("pus_katalog.judul");
if($keyw!='') $db->where_and("pus_katalog.judul LIKE '%".$keyw."%'");
$t=$db->query();
$ndata=mysql_num_rows($t);
?>
<div style="margin-right: 20px; margin-left: 20px;">
<table width="100%" cellspacing="0px" cellpadding="0" style="margin:auto"><tbody><tr><td align="center">
<table width="100%" cellspacing="0px" cellpadding="0" style="width:840px;margin-top:10px;margin-bottom:20px"><tr valign="top">
<td style="" width="100px"><div style="height: 32px;width: 85px;background: url('<?=IMGR?>siadu_32.png') no-repeat;"></div></td>
<td><div style="color: #fff;font: 18px <?=SFONT?>;cursor: default;">Perpustakaan</div></td>
</tr></table>
<div style="width:840px;height:30px;">
<form id="search_form" action="index.php" method="get">
if ($keyon == 'pengarang') {
$db->where_and("pus_pengarang.nama LIKE '%" . $keyw . "%'");
$keysel = 0;
} else {
if ($keyon == 'klasifikasi') {
if ($keysel != 0) {
$db->where_and("pus_klasifikasi.replid='" . $keysel . "'");
}
$keyw = '';
}
}
}
}
if ($keyon == 'pengarang') {
$db->where_and("pus_pengarang.replid<>0");
$db->order("pus_pengarang.nama");
} else {
if ($keyon == 'klasifikasi') {
$db->where_and("pus_klasifikasi.replid<>0");
$db->order("pus_klasifikasi.kode");
}
}
if ($urut == 'baru') {
$db->order("pus_katalog.tahunterbit DESC");
}
$db->order("pus_katalog.judul");
$t = $db->query();
$ndata = mysql_num_rows($t);
?>
<div style="margin-right: 20px; margin-left: 20px;">
<table width="100%" cellspacing="0px" cellpadding="0" style="margin:auto"><tbody><tr><td align="center">
if (count($tingkat) > 0) {
$PSBar->selection('Tingkat', iSelect('tingkat', $tingkat, $ting, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('tingkat', $ting);
echo '<div class="warnbox" style="float:left">Tidak ada kelas yang diajar.</div>';
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
// Query
$db = new xdb("aka_rpp");
$db->where_and("aka_rpp.guru='{$gid}'");
$db->where_and("aka_rpp.pelajaran='{$pel}'");
$db->order("aka_rpp.replid");
$t = $db->query();
$xtable->ndata_db($t);
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Unit', 'Deskripsi');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['unit'], 200);
$xtable->td(trim_textw($r['deskripsi'], 300));
$xtable->opt($r['replid'], 'u', 'd');
$xtable->row_end();
}
$xtable->foot();
} else {
