$xtable->head('@Barkode','@Judul','@Cek~C','Keterangan');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['barkode'],120);
$xtable->td(buku_judul($r['judul']),300);
$xtable->td($r['cek'],50,'c');
//td($a,$b='*',$c='',$k='',$atr=''){
//td($a,$b='*',$c='',$atr=''){
$xtable->td(nl2br($r['note']),'*','','id="cttn'.$r['replid'].'"');
$s='<button class="btn" title="Edit catatan." onclick="stocktake_note_form(\'uf\','.$r['replid'].')"><div class="bi_edit">Catatan</div></button>~80';
$xtable->opt($r['replid'],$s);
$xtable->row_end(); $n++;} $xtable->foot();
} else {
if($tamp==0){
$f=" yang belum dicek";
} else if($tamp==1){
$f=" yang sudah dicek";
} else {
$f="";
}
$xtable->nodata_cust('Tidak ada data item'.$f.'.');
}
$xtable->btnbar_begin();
echo '<div style="width:100%;float:left;text-align:center;margin-top:20px">';
echo '<button class="btn" style="margin-right:4px" onclick="stocktake_note_done(\'df\')">Kembali</button>';
echo '<button class="btnz" style="" onclick="stocktake_note_done(\'af\')">Selesai</button>';
echo '</div>';
$xtable->btnbar_end();
?>
$cl = '#ff1b1b';
} else {
if ($r['jenis'] == JT_UMUM) {
$cl = '#008aff';
} else {
$cl = '';
}
}
}
}
}
$xtable->td(fftgl($r['tanggal']) . '<br/><b><span style="color:' . $cl . '">' . $r['nomer'] . '</span></b>', 110);
$xtable->td(nl2br($r['uraian']), 250);
$t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid");
if (mysql_num_rows($t1) > 0) {
$s = '<div style="background:#fff"><table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">';
while ($r1 = mysql_fetch_array($t1)) {
$s .= '<tr><td>' . $r1['nrek'] . '</td><td width="40px" align="center">' . $r1['koderek'] . '</td><td width="100px" align="right">' . fRp($r1['debet']) . '</td><td width="100px" align="right">' . fRp($r1['kredit']) . '</td></tr>';
}
$s .= '</table></div>';
} else {
$s = '';
}
$xtable->td($s);
$xtable->opt_ud($r['replid']);
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
$xform->table_end(0);
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nopendaftaran'], 120);
$xtable->td($r['nama']);
$xtable->td(fRp($r['nominal']), 110, 'r');
$xtable->td(fRp($r['jmlbayar']), 110, 'r');
if ($r['lunas'] == '1') {
$s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>';
} else {
$s = '<button class="btn" title="Klik untuk transaksi pembayaran." onclick="E(\'pembayaran\').value=' . $r['replid'] . ';pembayaran_form(\'af\')" style="width:100px">Belum bayar</button>';
}
$xtable->td(fftgl($r['tglbayar']), 140);
$xtable->td($s, 110, 'c');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ditemukan data pembayaran.');
}
// End of Tabel transaksi
} else {
hiddenval('tampil', 'all');
echo '<div style="float:left;width:100%;margin-bottom:6px"><div class="warnbox" style="margin-right:4px">Belum ada modul pembayaran pendaftaran periode ini. Silahkan menambah modul pembayaran.</div></div><button onclick="modul_form(\'af\')" class="btnz" style="float:left" title="Tambah modul pembayaran."><div class="bi_add2">Modul pembayaran</div></button>';
}
hiddenval('kategori', 3);
hiddenval('reftipe', RT_PSB);
hiddenval('refid', $pros);
hiddenval('snama', 'Pendaftaran ' . $proses[$pros]);
} else {
departemen_warn(1);
}
//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);
$xtable->td(buku_judul($r['judul']));
$xtable->td($r['status'] == 1 ? 'Belum dikembalikan' : 'Dikembalikan', 120);
$xtable->td(fftgl($r['tanggal3']), 120);
if ($r['status'] == 1) {
$s = '<button class="btn" onclick="pengembalian_buku_form(\'uf\',' . $r['replid'] . ')" title="Kembaliakan item ini."><div class="bi_inb"> </div></button>~30';
} else {
$s = ' ';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('<span style="color:' . CLGREY . '"><i>Tidak ada data peminjaman.</i></span>');
}
echo '</div>';
}
}
}
$xtable->td(fhtgl($r['tanggal']), 80);
$xtable->td('<b><span style="color:' . $cl . '">' . $r['nomer'] . '<br/><span style="color:#444">' . jt_jenisbukti($r['jenis']) . '</span>' . ($r['nobukti'] == '' ? '' : '<br/><span style="color:#444">' . $r['nobukti'] . '</span>') . '</span></b>', 120);
$xtable->td(nl2br($r['uraian']), $ct_jurnaldetil == 1 ? 300 : '', '', 'id="xtd_urai' . $row . '"');
$xtable->td(fRp($r['nominal']), 100, 'r', 'id="xtd_nom' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? 'none' : '') . '"');
$t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid");
if (mysql_num_rows($t1) > 0) {
$s = '<div style="background:#fff"><table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">';
while ($r1 = mysql_fetch_array($t1)) {
$s .= '<tr><td>' . $r1['nrek'] . '</td><td width="40px" align="center">' . $r1['koderek'] . '</td><td width="100px" align="right">' . fRp($r1['debet']) . '</td><td width="100px" align="right">' . fRp($r1['kredit']) . '</td></tr>';
}
$s .= '</table></div>';
} else {
$s = '';
}
$xtable->td($s, '', '', 'id="xtd_jd' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? '' : 'none') . '"');
$s = '<button class="btn" title="Cetak bukti transaksi" onclick="transaksi_print(\'' . $r['nomer'] . '\')"><div class="bi_prib"> </div></button>';
$xtable->opt($r['replid'], 'u', 'd');
$row++;
}
$xtable->foot();
hiddenval('xtd_jd_num', $row);
echo '<form id="pageprinter" style="display:none" target="_blank" action="' . RLNK . 'print2.php?doc=jurnalumum&docname=Jurnal Umum&doprint=0" method="post"><input name="pagesql" type="hidden" value="' . $db->getsql() . '" /></form>';
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
}
$xtable->ndata = mysql_num_rows($t);
$xtable->search_info($keyw, 'Hasil pencarian item dengan barkode atau judul "<b>' . $keyw . '</b>".', "E('pskeyword').value='';siswakelas_get_cari(1)");
if ($xtable->ndata > 0) {
//$xtable->optw='50px';
$xtable->head('<input id="pscekt" type="checkbox" onclick="peminjaman_buku_get_cekall(this.checked)" />~C', 'Barkode', 'Callnumber', 'Judul');
$n = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$s = '<input id="pscek' . $n . '" value="' . $r['replid'] . '" type="checkbox" onclick="peminjaman_buku_get_cek(' . $n . ',this.checked)" />';
$xtable->td($s, 20, 'c');
$xtable->td(srcrep($keyw, $r['barkode']), 100);
//$xtable->td($r['idbuku'],120);
$xtable->td($r['callnumber'], 80);
$xtable->td(srcrep($keyw, buku_judul($r['judul'])));
if (admin_isoperator()) {
$s = '<button class="btn" onclick="peminjaman_buku_get_pilih_id(' . $n++ . ')">Pilih</button>~40px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
hiddenval('psceknum', $n);
} else {
$xtable->nodata_cust('Tidak data item dengan barkode atau judul <b>' . $keyw . '</b> di lokasi ini.');
}
} else {
$xtable->nodata_cust('<span style="color:' . CLGREY . '"><i>Masukkan barkode atau judul item.</i></span>');
}
}
$PSBar->end();
hiddenval('kelas', $kls);
kelas_warn(1, 'float:left');
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
$t = mysql_query("SELECT * FROM aka_siswa WHERE kelas='{$kls}' AND aktif='1' ORDER BY nis");
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
$xtable->optw = '40px';
$xtable->head('NIS', 'NISN', 'Nama');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nis'], 120);
$xtable->td($r['nisn'], 120);
$xtable->td($r['nama']);
if (admin_isoperator()) {
$s = '<button class="btn" title="Batalkan penempatan siswa" onclick="penempatan_form(\'df\',\'' . $r['replid'] . '\')"><div class="bi_canb"> </div></button>';
} else {
$s = '<div style="height:23px;width:20px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Belum ada siswa yang menempati kelas ini.');
}
}
} else {
$absen = '';
$info = '';
}
$s = presensi_icon($absen);
$ifo = $info;
if ($ifo != '') {
$ifo = '<div id="absen_info_' . $r['replid'] . '_' . $i . '" style="display:none;white-space:nowrap;background:url(\'' . IMGR . 'absen_ibox.png\') top right no-repeat;height:24px;padding-right:10px;padding-top:2px;padding-left:10px;position:absolute;top:-25px;right:0px;color:#fff;text-align:left">' . $info . '</div>';
$ifo .= '<img src="' . IMGR . '/absen_info.png?asd" style="position:absolute;top:0px;right:0px"/>';
}
echo '<td style="width:16px;text-align:center;position:relative" onmouseover="EShow(\'absen_info_' . $r['replid'] . '_' . $i . '\')" onmouseout="EHide(\'absen_info_' . $r['replid'] . '_' . $i . '\')">' . $s . $ifo . '</td>';
//$xtable->td(,20,'c');
}
$per = $nabsen > 0 ? ceil($nhadir * 100 / $nabsen) : '';
$xtable->td('<span style="font-size:11px">' . $per . '</span>', 28, 'c');
$s = '<button title="Edit presensiguru siswa" class="btn" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_f . '\');presensiguru_form(\'uf\',' . $r['replid'] . ')"><div class="bi_editb"> </div></button>';
$xtable->td($s, 24, 'c');
$xtable->row_end();
}
$xtable->foot();
echo '<div class="tbltopbar" style="margin-top:20px;width:100%">';
$st = 'float:left;margin-right:4px;height:12px;width:12px;padding:2px;font-size:11px;text-align:center;background:';
echo '<div style="float:left;margin-top:4px;margin-right:20px">', '<div class="sfont" style="' . $st . '#00ff00">H</div>', '<div class="sfont" style="float:left;margin-right:10px">= Hadir</div>', '<div class="sfont" style="' . $st . '#ffff00">S</div>', '<div class="sfont" style="float:left;margin-right:10px">= Sakit</div>', '<div class="sfont" style="' . $st . '#ff9000">I</div>', '<div class="sfont" style="float:left;margin-right:10px">= Ijin</div>', '<div class="sfont" style="' . $st . '#ff0000">A</div>', '<div class="sfont" style="float:left;margin-right:10px">= Abstain</div>', '</div>';
echo '</div>';
} else {
$xtable->nodata_cust('Tidak ada data guru pada tahun ajaran ini.');
}
}
} else {
departemen_warn();
}
?>
<button class="find21" title="Cari siswa" style="float:left;margin-top:2px" onclick="pendataan_saudara_siswacari(1)"></button>
</div>
<?php
notifbox();
if ($keyw != '') {
$t = mysql_query("SELECT * FROM aka_siswa WHERE nama LIKE '%{$keyw}%' OR nis='{$keyw}' ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
//$xtable->optw='50px';
$xtable->head('NIS', 'Nama', 'Kelas');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nis'], 120);
$xtable->td($r['nama']);
$xtable->td(kelas_name($r['kelas']));
if (admin_isoperator()) {
$s = '<button class="btn" title="Lihat detil" onclick="pendataan_saudara_detil(\'' . $r['replid'] . '\')"><div class="bi_srcb"> </div></button> <button class="btn" onclick="pendataan_saudara_setsiswa(\'' . $r['nama'] . '\',\'' . departemen_name($r['departemen']) . '\',\'' . $r['tgllahir'] . '\')">Pilih</button>~72px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak data siswa dengan nama atau nis <b>' . $keyw . '</b>.');
}
} else {
$xtable->nodata_cust('Cari siswa dengan nama atau nis.');
}
<td width="200px">
<?php
echo iText('keyword', $keyword, 'width:' . '375px;float:left;margin-right:2px');
?>
<button class="find21" style="float:left;margin-top:2px" title="Cari" onclick="pencarian_get()"></button>
</td>
<td width="*"> </td></tr>
</table></div>
<?php
$xtable->btnbar_f($fmsg);
$xtable->noopt = true;
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Kode', 'Nama', 'Keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
//$num_judul = @mysql_num_rows(mysql_query("SELECT * FROM sar_pustaka WHERE format=".$r['replid']));
//$num_pustaka = @mysql_fetch_row(mysql_query("SELECT COUNT(d.replid) FROM sar_pustaka p, sar_daftarpustaka d WHERE d.pustaka=p.replid AND p.format=".$r['replid']));
$xtable->td($r['kode'], 120);
$xtable->td($r['nama'], 250);
//$xtable->td($num_judul,100);
//$xtable->td($num_pustaka[0],100);
$xtable->td(nl2br($r['keterangan']));
//$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ditemukan hasil dari pencarian ini.');
}
}
$tid = 'n-' . $r['replid'] . '-' . $pel . '-' . $y['replid'];
$xtable->td(iText($tid, $n, 'width:100%;text-align:center') . hiddenval('nilai' . $b++, $tid), 60, 'c');
}
$nc = count($ni);
$n = 0;
if ($tb > 0) {
for ($nk = 0; $nk < $nc; $nk++) {
$n += $ni[$nk] * $nb[$nk] / $tb;
}
}
$total += $n;
$xtable->td(number_format($n, 2), 80, 'c');
//$xtable->td(nl2br($r['keterangan']));
//$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->row_begin();
echo '<td> </td><td colspan="' . ($nc + 1) . '" align="right"><b>Rata-rata</b></td><td align="center"><b>' . number_format($total / $xtable->ndata, 2) . '</b></td>';
$xtable->row_end();
$xtable->foot();
hiddenval('jml_nilai', $b);
} else {
$xtable->nodata();
}
} else {
$xtable->nodata_cust('Tidak ada pengujian pada pelajaran ini. Silahkan menambahkan jenis pengujian untuk pelajaran ini.');
}
} else {
departemen_warn();
}
$t=mysql_query($sql.$xtable->pageorder_sql('nama','tanggal1','tanggal2'));
if($xtable->ndata>0){
// Table head
$xtable->head('@Nama Stock Opname','@Tanggal Mulai','@Tanggal selesai','Rangkuman','keterangan');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['nama'],200);
$xtable->td(fftgl($r['tanggal1']),120);
$xtable->td(fftgl($r['tanggal2']),120);
$tot=$r['nitem'];
$ncek=$r['nceky'];
$nnocek=$tot-$ncek;
$nwn=$r['nnote'];
$nnn=$nnocek-$nwn;
$s='<table class="stable" cellspacing="0" cellpadding="0" border="0" style="border:none !important">';
$s.='<tr><td style="border:none !important" width="180px">Total item di database</td><td style="border:none !important">: '.$tot.' item</td></tr>';
$s.='<tr><td style="border:none !important">Item dicek</td><td style="border:none !important">: '.$ncek.' item</td></tr>';
$s.='<tr><td style="border:none !important">Item hilang</td><td style="border:none !important">: '.$nnocek.' item</td></tr>';
$s.='<tr><td style="border:none !important">Item hilang dengan keterangan</td><td style="border:none !important">: '.$nwn.' item</td></tr>';
$s.='<tr><td style="border:none !important">Item hilang tanpa keterangan</td><td style="border:none !important">: '.$nnn.' item</td></tr>';
$s.='</table>';
$xtable->td($s,250);
$xtable->td(nl2br($r['keterangan']));
$s='<button class="btn" title="Cetak laporan" onclick="stocktake_report('.$r['replid'].')"><div class="bi_prib"> </div></button>~24';
$xtable->opt($r['replid'],$s,'u','d');
$xtable->row_end();}$xtable->foot();
}else{$xtable->nodata_cust('Tidak ada data riwayat stock opname.');}
?>
kelas_warn(1);
$PSBar->pass = false;
}
}
$PSBar->end();
$db = siswa_db_bykelas($kls, $ting, "tgllahir");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$xtable->search_box();
$xtable->search_info('data siswa dengan {keyon} "<b>{keyw}</b>"' . ($kls == 0 ? '' : 'pada kelas ' . $kelas[$kls]) . '.');
if ($xtable->ndata > 0) {
$xtable->head('NIS', 'Nama');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nis'], 120);
$xtable->td($r['nama']);
if (admin_isoperator()) {
$s = '<button class="btn" title="Lihat detil" onclick="pendataan_saudara_detil(\'' . $r['replid'] . '\')"><div class="bi_srcb"> </div></button> <button class="btn" onclick="pendataan_saudara_set(\'' . $r['nama'] . '\',\'' . $r['ndepartemen'] . '\',\'' . $r['tgllahir'] . '\')">Pilih</button>~72px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data siswa' . ($kls == 0 ? '' : ' pada kelas ini') . '.' . $kls);
}
$fform->foot(0);
//>
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_begin();
//echo iTextSrc('pskeyword',$keyw,'float:left~width:250px','NIS atau nama siswa...',"peminjaman_member_get_siswa(1)");
$xtable->search_box();
$xtable->btnbar_end();
$t = mysql_query("SELECT * FROM aka_siswa WHERE kelas='{$kls}' " . ($keyw == "" ? "" : " AND (nama LIKE '%{$keyw}%' OR nis='{$keyw}') ") . " ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
//$xtable->search_info($keyw,'Hasil pencarian data siswa dengan NIS atau nama "<b>'.$keyw.'</b>".',"E('pskeyword').value='';peminjaman_member_get_siswa(1)");
$xtable->search_info();
if ($xtable->ndata > 0) {
//$xtable->optw='50px';
$xtable->head('!NIS', 'Nama');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td(srcrep($keyw, $r['nis']), 100);
$xtable->td(srcrep($keyw, $r['nama']));
if (admin_isoperator()) {
$s = '<button class="btn" title="Lihat detil" onclick="peminjaman_member_siswa_view(\'' . $r['replid'] . '\')"><div class="bi_srcb"> </div></button> <button class="btn" onclick="pengembalian_member_pilih(' . $r['replid'] . ',1,\'' . $r['nama'] . '\')">Pilih</button>~75px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak data siswa dengan NIS atau nama <b>' . $keyw . '</b> di kelas ini.');
}
}
$db = siswa_db_byangkatan($angk);
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$xtable->search_box('nis atau nama siswa');
$xtable->search_info('data siswa dengan nis atau nama "<b>{keyw}</b>"' . ($angk == 0 ? '' : ' pada angkatan ' . $angkatan[$angk]) . '.');
$fid = 0;
if ($xtable->ndata > 0) {
$xtable->head('NIS', 'Nama', '{40px}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
if ($fid == 0) {
$fid = $r['replid'];
}
$xtable->td($r['nis'], 100);
$xtable->td($r['nama']);
if (admin_isoperator()) {
$s = '<button class="btn" title="Proses" onclick="E(\'siswa\').value=' . $r['replid'] . ';pembayaran_proses_get()"><div class="bi_arrow2b"> </div></button>~36px';
} else {
$s = '<div style="height:23px;width:36px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data siswa' . ($angk == 0 ? '' : ' pada angkatan ini') . '.');
}
$xform->table_end(0);
hiddenval('siswa_list_num', $xtable->ndata);
hiddenval('siswa_list_firstid', $fid);
}
//Status
$xtable->td($s,110);
$xtable->td($r['status']==1?'Dipinjam':'Dikembalikan',80);
//Tgl Dikembalikan
$xtable->td(fftgl($r['tanggal3']),110);
if($r['status']==0){
$telat=diffDay($r['tanggal3'],$r['tanggal2']);
if($telat<=0)
$telat='-';
//$s=$telat;
}
$xtable->td(($r['telat']==0?'-':$r['telat'].' hari'),60);
//$xtable->td($r['telat1'],60);
$xtable->td($r['keterangan']==''?' ':nl2br($r['keterangan']));
if($r['status']==1){
$s='<button class="btn" onclick="sirkulasi_pengembalian_item_form(\'uf\','.$r['replid'].')" title="Kembaliakan item ini."><div class="bi_inb"> </div></button>~30';
} else {
$s=' ';
}
$xtable->opt($r['replid'],$s);
$xtable->row_end();}$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data.');
}
?>
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_begin();
if ($xtable->cari == 0) {
echo '<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"><div style="float:left;margin-right:4px;width:100px"><b>Jumlah koleksi:</b></div><div style="float:left;margin-right:4px"><b>' . $xtable->ndata . '</b> item</div></div>';
}
$xtable->search_box();
//$xtable->btnbar_print();
$xtable->btnbar_end();
$xtable->search_info();
if ($xtable->ndata > 0) {
$xtable->head('@Barkode', '@Judul', '@Callnumber', '@Klasifikasi', '@Pengarang', '@Penerbit', '@Status');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['barkode'], 120);
$xtable->td(buku_judul($r['judul']));
$xtable->td($r['callnumber'], 80);
$xtable->td(klasifikasi_name($r['klasifikasi']), 200);
$xtable->td($r['n2'], 120);
$xtable->td($r['n3'], 120);
$xtable->td($r['status'] == 1 ? 'Tersedia' : 'Dipinjam', 80);
if ($SOUF == 0) {
$xtable->opt($r['replid'], 'u', 'd');
}
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data buku' . ($jen == 0 ? '' : ' jenis ' . $jenisbuku[$jen]) . ($lok == 0 ? '' : ' pada lokasi ini') . '.');
}
}
$db=new xdb("pus_buku");
$db->field("pus_buku:replid","pus_buku:barkode","pus_katalog:judul");
$db->join("katalog","pus_katalog");
$db->where_and("pus_buku.lokasi='$lok'");
$db->where_and("pus_buku.status='1'");
$db->where_and("!( NOT EXISTS (SELECT pus_tpjm.replid FROM pus_tpjm WHERE pus_tpjm.buku=pus_buku.replid ) )");
$db->where_and($xtable->search_sql_get());
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_katalog.judul'));
if($xtable->ndata>0){
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@Barkode','@Judul','{44px}');
$n=0;
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
$xtable->td($r['barkode'],100);
$xtable->td(buku_judul($r['judul']));
if(admin_isoperator()) $s='<button class="btn" onclick="xtable3_cekall(false);xtable3_sel('.$n.');sirkulasi_peminjaman_form_buku_form(\'a\',\'0\',true)">Pilih</button>~40px';
else $s='<div style="height:23px;width:40px"></div>';
$xtable->opt($r['replid'],$s);
$n++;
$xtable->row_end();}$xtable->foot();
echo '</div>';
} else { $xtable->nodata_cust(); }
}
?>
$xtable->docname = "Data Siswa Angkatan " . angkatan_name($angk);
$xtable->printparams = array('angkatan' => angkatan_name($angk));
// Query
$db = new xdb("aka_siswa");
$db->field("aka_siswa:replid,nis,nisn,nama,tmplahir,tgllahir");
$db->where_and("aka_siswa.angkatan='{$angk}'");
$db->where_and($xtable->search_sql_get());
$t = $xtable->use_db($db, $xtable->pageorder_sql('nis', 'nisn', 'nama'));
$xtable->btnbar_f('print', 'srcbox');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir', '{50px}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nis'], 80);
$xtable->td($r['nisn'], 120);
$xtable->td($r['nama']);
$xtable->td($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 100);
//$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>';
$xtable->opt($r['replid'], 'v');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data siswa pada angkatan ini.');
}
}
}
} else {
departemen_warn();
}
if ($PSBar->pass) {
$xtable->search_box('nis atau nama siswa');
$db = siswa_db_byangkatan($angk);
$db->where_and("!( NOT EXISTS (SELECT aka_siswa_kelas.replid FROM aka_siswa_kelas WHERE aka_siswa_kelas.siswa=aka_siswa.replid AND aka_siswa_kelas.kelas='{$kls}') )");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('aka_siswa.nis', 'aka_siswa.nama'));
if ($xtable->ndata > 0) {
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@nis', '@nama', '{44px}');
$n = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['nis'], 100);
$xtable->td($r['nama']);
if (admin_isoperator()) {
$s = '<button class="btn" onclick="xtable2_cekall(false);xtable2_sel(' . $n . ');siswa_pendataan_kelas_siswa_form(\'a\',\'0\',true)"">Pilih</button>~40px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$n++;
$xtable->row_end();
}
$xtable->foot();
echo '</div>';
} else {
$xtable->nodata_cust();
}
}
$db=new xdb("pus_buku");
$db->field("pus_buku:replid,barkode,idbuku","pus_katalog:judul,callnumber");
$db->join("katalog","pus_katalog");
$db->where_and("pus_buku.lokasi='$lok'");
$db->where_and("!( NOT EXISTS (SELECT pus_tpjm.replid FROM pus_tpjm WHERE pus_tpjm.buku=pus_buku.replid ) )");
$db->where_and($xtable->search_sql_get());
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_buku.callnumber','pus_katalog.judul'));
if($xtable->ndata>0){
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@Barkode','@Callnumber','@Judul','{44px}');
$n=0;
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
$xtable->td($r['barkode'],100);
$xtable->td($r['callnumber'],80);
$xtable->td(buku_judul($r['judul']));
if(admin_isoperator()) $s='<button class="btn" onclick="xtable2_cekall(false);xtable2_sel('.$n.');tools_label_buku_form(\'a\',\'0\',true)">Pilih</button>~40px';
else $s='<div style="height:23px;width:40px"></div>';
$xtable->opt($r['replid'],$s);
$n++;
$xtable->row_end();}$xtable->foot();
echo '</div>';
} else { $xtable->nodata_cust('<span style="color:#aaa"><i>Semua item telah masuk daftar cetak.</i></span>'); }
}
?>
$fmod='sirkulasi_peminjaman_form_buku';
$xtable = new xtable($fmod,'Item','',2);
$xtable->pageorder='pus_tpjm.replid DESC';
// Query
$db=new xdb("pus_tpjm");
$db->field('pus_tpjm:*','pus_buku:barkode,idbuku','pus_katalog:judul');
$db->join('buku','pus_buku');
$db->joinother('pus_buku','katalog','pus_katalog','replid');
$db->where("ssid='$ssid'");
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
echo '<div style="float:none !important">';
if($xtable->ndata>0){
// Table head
$xtable->head('Barkode','Judul','{44px}');
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(buku_judul($r['judul']));
$s='<button class="btn" onclick="'.$fmod.'_form(\'d\','.$r['replid'].')" title="Keluarkan dari daftar"><div class="bi_canb"> </div></button>~40';
$xtable->opt($r['replid'],$s);
$xtable->row_end();}$xtable->foot();
}else{
$xtable->nodata_cust('<span style="color:'.CLGREY.'"><i>Belum ada item yang dipilih.</i></span>');
}
echo '</div>';
?>
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
$t = mysql_query("SELECT * FROM aka_siswa WHERE kelas='{$kls}' ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
//$xtable->optw='50px';
$xtable->head('NIS', 'NISN', 'Nama');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nis'], 120);
$xtable->td($r['nisn'], 120);
$xtable->td($r['nama']);
if (admin_isoperator()) {
$s = '<button class="btn"onclick="pendataan_saudara_setsiswa(\'' . $r['nama'] . '\',\'' . departemen_name($r['departemen']) . '\',\'' . $r['tgllahir'] . '\')">Pilih</button>~40px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data siswa pada kelas ini.');
}
}
} else {
departemen_warn(1);
}
<?php
require_once MODDIR . 'xtable/xtable.php';
require_once MODDIR . 'control.php';
$fmod = 'peminjaman_tabelcari';
$xtable = new xtable($fmod);
$keyword = gpost('keyword');
if ($keyword != '') {
// Query
$sql = "SELECT sar_barang.*,sar_katalog.nama FROM sar_barang LEFT JOIN sar_katalog ON sar_katalog.replid=sar_barang.katalog WHERE sar_barang.kode='{$keyword}' OR sar_katalog.nama LIKE '%{$keyword}%'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
// Table head
$xtable->head('kode');
while ($r = mysql_fetch_array($t)) {
$xtable->row_click($r['replid'], 'v');
$xtable->row_begin();
$n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='" . $r['replid'] . "'"));
$xtable->td($r['kode'], 80);
$xtable->opt($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ditemukan data barang dengan kode atau nama <b>' . $keyword . '</b>.');
}
}
hiddenval('kriteria', $krit);
kriteria_warn(0, 'float:left');
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
$t = mysql_query("SELECT psb_calonsiswa.*,aka_kelas.replid as idkelas, aka_kelas.kelas as nkelas,aka_tingkat.replid as idtingkat FROM psb_calonsiswa LEFT JOIN aka_kelas ON aka_kelas.replid=psb_calonsiswa.kelas LEFT JOIN aka_tingkat ON aka_tingkat.replid=aka_kelas.tingkat WHERE psb_calonsiswa.status='1' " . ($pros == 0 ? "" : " AND psb_calonsiswa.proses='{$pros}' ") . ($kel == 0 ? "" : " AND psb_calonsiswa.kelompok='{$kel}'") . ($krit == 0 ? "" : " AND psb_calonsiswa.kriteria='{$krit}' ") . " ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
$xtable->optw = '40px';
$xtable->head('No Pendaftaran', 'Nama', 'Kelas~C');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nopendaftaran'], 100);
$xtable->td($r['nama']);
$k = $r['idkelas'] != 0 ? '<a class="linkb" href="javascript:void(0)" onclick="penempatan_kelas_get(' . $r['idkelas'] . ',' . $r['idtingkat'] . ')" title="Tampilkan kelas ' . $r['nkelas'] . '">' . $r['nkelas'] . '</a>' : '';
$xtable->td($k, 100, 'c');
if (admin_isoperator() && $r['idsiswa'] == 0) {
$s = '<button class="btn" title="Tempatkan siswa" onclick="penempatan_form(\'af\',<id>)"><div class="bi_arrow2b"> </div></button>';
} else {
$s = '<div style="height:23px;width:20px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Belum ada calon siswa yang diterima pada kelompok penerimaan ini.');
}
}
$xtable->btnbar_end();
$xtable->search_info();
$membertipe=array(1=>'Siswa',2=>'Pegawai',3=>'Member luar');
if($xtable->ndata>0){
$xtable->head('@!ID Member','@Nama member','@Jenis member','@Jumlah Item Dipinjam{R,150px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
if($r['mtipe']==1){
$xtable->td($r['nis'],120);
$xtable->td($r['nsiswa']);
}
else if($r['mtipe']==2){
$xtable->td($r['nip'],120);
$xtable->td($r['npegawai']);
} else {
$xtable->td($r['nid'],120);
$xtable->td($r['nmember']);
}
$xtable->td($membertipe[$r['mtipe']],150);
$xtable->td($r['cnt'].' item',150,'r');
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ada data buku pada lokasi ini.');
}
}
?>
// Query
$sql = "SELECT sar_barang.*,sar_katalog.nama FROM sar_barang LEFT JOIN sar_katalog ON sar_katalog.replid=sar_barang.katalog WHERE (sar_barang.kode='{$keyword}' OR sar_katalog.nama LIKE '%{$keyword}%')";
$t = mysql_query($sql);
$nd = mysql_num_rows($t);
$sql = "SELECT sar_barang.*,sar_katalog.nama FROM sar_barang LEFT JOIN sar_katalog ON sar_katalog.replid=sar_barang.katalog WHERE (sar_barang.kode='{$keyword}' OR sar_katalog.nama LIKE '%{$keyword}%') AND ( NOT EXISTS (SELECT * FROM sar_dftp WHERE sar_dftp.barang=sar_barang.replid) )";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
//echo '<textarea>';
echo '<div style="float:none !important">';
if ($xtable->ndata > 0) {
// Table head
$xtable->tblstyle = 'float:left;margin-top:4px';
$xtable->head('Kode', 'Nama Barang');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kode'], 80);
$xtable->td($r['nama']);
$xtable->opt($r['replid'], '<button class="btn" onclick="peminjaman_ketabelpinjam(<id>,' . $r['katalog'] . ')"><div class="bi_out">Pinjam</div></button>');
$xtable->row_end();
}
$xtable->foot();
} else {
if ($nd > 0) {
$xtable->nodata_cust('<span style="color:' . CLGREY . '"><i>Barang dengan kode atau nama <b>' . $keyword . '</b> sudah masuk daftar barang yang dipinjam.</i></span>');
} else {
$xtable->nodata_cust('Tidak ditemukan barang dengan kode atau nama <b>' . $keyword . '</b>.');
}
}
echo '</div>';
//echo '</textarea>';
}
