//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>';
$rk = mysql_fetch_array($tk);
$lok = $r['lokasi'];
$sat = $r['satuan'];
$tingb = $r['tingkatbuku'];
$lokasi = lokasi_r($lok);
$satuan = satuan_r($sat);
$tingkatbuku = tingkatbuku_r($tingb);
}
$fform->ptop = 20;
$fform->head();
if ($opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
hiddenval('katalog', $r['katalog']);
$fform->fg('Data buku');
$fform->fl('Judul', '<b>' . buku_judul($rk['judul']) . '</b>');
hiddenval('nbuku', 0);
$fform->fi('ID buku', iText('idbuku', $r['idbuku'], $fform->rwidths, '', '', 'disabled'));
//hiddenval('idbuku',$r['idbuku']);
$fform->fi('Barkode', iText('barkode', $r['barkode'], $fform->rwidths, '', '', 'disabled'));
$fform->fi('Callnumber', iText('callnumber', $r['callnumber'], $fform->rwidths));
$fform->fi('Sumber', iRadio('sumber1', 'sumber', 0, 'Beli', $r['sumber'], '', 'onclick="katalog_buku_getkode(' . $cid . ')"'));
$fform->fi('', iRadio('sumber2', 'sumber', 1, 'Pemberian', $r['sumber'], '', 'onclick="katalog_buku_getkode(' . $cid . ')"'));
$fform->fi('Harga', iSelect('satuan', $satuan, $sat) . ' ' . iText('harga', $r['harga'], 'width:120px'));
$fform->fi('Tanggal diperoleh', inputTanggal('tanggal', $r['tanggal']));
$fform->fg('Alokasi buku');
$fform->fi('Lokasi', iSelect('tlokasi', $lokasi, $lok, '', 'katalog_buku_getkode(' . $cid . ')'));
$fform->fi('Tingkat', iSelect('ttingkatbuku', $tingkatbuku, $tingb, '', 'katalog_buku_getkode(' . $cid . ')'));
} else {
if ($opt == 'df') {
// Delete form
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Barkode Item', '@Judul Item', '@Peminjam', '@Tgl peminjaman', '@Tgl pengembalian', '@Tgl dikembalikan', '@Terlambat{R}', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
if ($r['mtipe'] == 1) {
$member = $r['nsiswa'] . '<br/>NIS: ' . $r['nis'];
} else {
if ($r['mtipe'] == 2) {
$member = $r['npegawai'] . '<br/>NIP: ' . $r['nip'];
} else {
$member = "N/a";
}
}
$xtable->td($r['barkode'], 120, '', 'item');
$xtable->td(buku_judul($r['judul']), 250, '', 'item');
$xtable->td($member, 200, '', 'member');
$xtable->td(fftgl($r['tanggal1']), 120);
if ($r['telat'] > 0) {
$s = '<span style="color:red">' . fftgl($r['tanggal3']) . '</span>';
} else {
$s = fftgl($r['tanggal3']);
}
$xtable->td(fftgl($r['tanggal2']), 120);
$xtable->td($s, 120);
$xtable->td($r['telat'] > 0 ? $r['telat'] . ' hari' : '-', 80, 'r');
$xtable->td($r['keterangan'] == '' ? ' ' : nl2br($r['keterangan']));
$xtable->row_end();
}
$xtable->foot();
} else {
<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0;
// form Module
$fmod='stocktake_note';
$dbtable=stocktake_ctable();
$fform=new fform($fmod,$opt,$cid);
$inp=app_form_gpost('note');
if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false;
$q=dbUpdate($dbtable,$inp,"replid='$cid'");
//$fform->notif($q);
if($q) echo nl2br($inp['note']);
else echo "-0-";
} else {
$r=dbSFA("*",$dbtable,"W/replid='$cid'");
$t1=mysql_query("SELECT pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='".$r['buku']."' LIMIT 0,1");
$r1=mysql_fetch_array($t1);
$fform->head();
if($opt=='af' || $opt=='uf'){ require_once(MODDIR.'control.php'); // Add or Edit form
$fform->fc('Tambahkan catatan untuk item:');
$fform->fl('Barkode',$r['barkode']);
$fform->fl('Judul',buku_judul($r1['judul']));
$fform->fa('Keterangan',iTextarea('note',$r['note'],$fform->rwidths,3));
}
$fform->foot();
} ?>
if ($keyw != '') {
$t = mysql_query("SELECT pus_buku.*,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.lokasi='{$lok}' AND pus_buku.status='1' " . ($keyw == "" ? "" : " AND (pus_katalog.judul LIKE '%{$keyw}%' OR pus_buku.barkode='{$keyw}') ") . " ORDER BY pus_buku.barkode,pus_katalog.judul");
$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>');
$inp=app_form_gpost('klasifikasi-kode','klasifikasi','pengarang','callnumber','penerjemah','editor','penerbit','tahunterbit','kota','isbn','issn','bahasa','seri','volume','edisi','jenisbuku','photo','deskripsi','halaman','dimensi');
$inp['judul']=gpost('judul1').'`'.gpost('judul2');
if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; $ec=0;
if($opt=='a'){ // add
$q=dbInsert($dbtable,$inp);
$cid=mysql_insert_id();
}
else if($opt=='u') { // edit
$q=dbUpdate($dbtable,$inp,"replid='$cid'");
}
else if($opt=='d'){ // delete
$q=dbDel($dbtable,"replid='$cid'");
$q=dbDel("pus_buku","katalog='$cid'");
}
echo $cid;
$fform->notif($q);
} else {
if($opt=='uf'||$opt=='df'){ // Prepocessing form
$r=dbSFA("*",$dbtable,"W/replid='$cid'");
} else {
$r=array();
}
$fform->head();
if($opt=='df'){ // Delete form
$fform->dlg_del(buku_judul($r['judul']));
} $fform->foot();
} ?>
echo '<img style="float:left" src="' . $photodir . $f . '.php?id=' . $d . '" ' . $sz . ' style="display:"/>';
} else {
echo '<div style="border-left:8px solid #666;width:90px;height:100px;background:#f0f0ff;font:11px Verdana;text-align:center;padding:15px 6px"><b>' . $t . '</b></div>';
}
echo '</div></div>';
}
$row = 0;
$kol = 0;
echo '<table cellspacing="0" cellpadding="0" style="border:10px solid #eebd46;" width="100%"><tr><td>';
echo '<div style="float:left;width:100%;height:600px;max-height:600px;overflow:auto;background:url(\'' . IMGR . '/shelfbg.png\')">';
echo '<div style="float:left;background:url(\'' . IMGR . '/shelfbg.png\')">';
//echo '<div style="float:left;height:180px;width:100%; repeat-x">';
while ($r = mysql_fetch_array($t)) {
//for($i=0;$i<15;$i++){
//if($r['replid']==5) $r['replid']=0;
photof($r['replid'], 'katalog', buku_judul($r['judul']));
//}
}
//echo '</div>';
echo '</div></div>';
echo '</td></tr></table>';
?>
</div>
</td></tr></tbody></table>
</div>
</div>
</div>
<script type="text/javascript" language="javascript">
/** Floating Form **/
function close_fform(){
if(E('fform').style.display!='none'){
if($xtable->ndata>0){
// Table head
$xtable->head('@Tgl peminjaman','@Peminjam','@Barkode Item','@Judul Item','@Tgl pengembalian','@Status','@Tgl dikembalikan','Terlambat{60px}','Keterangan','{44px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
if($r['mtipe']==1){
$member=$r['nsiswa'].'<br/>NIS: '.$r['nis'];
} else if($r['mtipe']==2){
$member=$r['npegawai'].'<br/>NIP: '.$r['nip'];
} else {
$member=$r['nmember'].'<br/>No. ID: '.$r['nid'];
}
$xtable->td(fftgl($r['tanggal1']),110);
$xtable->td($member,150);
$xtable->td($r['barkode'],120,'','item');
$xtable->td(buku_judul($r['judul']),250);
//Tgl Pengembalian
$s=fftgl($r['tanggal2']); //$telat='-';
if($r['status']!=0){
$lewat=diffDay($r['tanggal2']);
if($lewat<0 && $r['status']!=0){
$s='<span style="color:red">'.$s.'</span>';
}
} else {
$telat=diffDay($r['tanggal3'],$r['tanggal2']);
//if($telat>0)$telat='<br/><span style="color:#ff9000">Terlambat: '.$telat.' hari</span>';
//else $telat="";
}
//Status
$xtable->td($s,110);
if($rk['penerbit']!=0)$terbitan=penerbit_name($rk['penerbit']);
if($rk['kota']!=''){
if($terbitan!='')$terbitan.=', ';
$terbitan.=$rk['kota'];
}
if($rk['tahunterbit']!=''){
if($terbitan!='')$terbitan.=', ';
$terbitan.=$rk['tahunterbit'];
}
?>
<div class="tbltopmbar" style="float:left;margin-top:10px;margin-bottom:10px">
<table class="stable" cellspacing="0" cellpadding="0" width="100%"><tr valign="top">
<td width="400px">
<table class="stable" cellspacing="0" cellpadding="0">
<tr height="24px"><td colspan="2"><b>Informasi Katalog:</b></td></tr>
<tr height="24px"><td width="140px">Judul:</td><td><?=buku_judul($rk['judul'])?></td></tr>
<tr height="24px"><td width="140px">Klasifikasi:</td><td><?=klasifikasi_name($rk['klasifikasi'])?></td></tr>
<tr height="24px"><td width="140px">Pengarang:</td><td><?=pengarang_name($rk['pengarang'])?></td></tr>
<tr height="24px"><td width="140px">Callnumber:</td><td><?=$rk['callnumber']?></td></tr>
<tr height="24px"><td width="140px">Penerjemah:</td><td><?=$rk['penerjemah']?></td></tr>
<tr height="24px"><td width="140px">Editor:</td><td><?=$rk['editor']?></td></tr>
<tr height="24px"><td width="140px">Terbitan:</td><td><?=$terbitan?></td></tr>
<tr height="24px"><td width="140px">ISBN:</td><td><?=$rk['isbn']?></td></tr>
<tr height="24px"><td width="140px">ISSN:</td><td><?=$rk['issn']?></td></tr>
<tr height="24px"><td width="140px">Bahasa:</td><td><?=bahasa_name($rk['bahasa'])?></td></tr>
<tr height="24px"><td width="140px">Seri:</td><td><?=$rk['seri']?></td></tr>
<tr height="24px"><td width="140px">Volume:</td><td><?=$rk['volume']?></td></tr>
<tr height="24px"><td width="140px">Edisi:</td><td><?=$rk['edisi']?></td></tr>
<tr height="24px"><td width="140px">Jenis koleksi:</td><td><?=jenisbuku_name($rk['jenisbuku'])?></td></tr>
</table>
</td>
for($l=0;$l<$twx_n;$l++){
$tx=$tx+$twx[$l];
}
$gy=$pdf->GetY()+1;
$pdf->SetY($gy);
$pdf->Line($dcMarginL,$gy,$tx,$gy);
}
}
$i=0;
$ny=$pdf->GetY();$my=0; $i=0;$pdf->MultiCell($twx[$i], 0, $row++, 0, $tax[$i++], 0, 0, '', '', true);if($pdf->getLastH()>$my)$my=$pdf->getLastH();
// 10. Row data: >> Edit
cetak_kolom($r['barkode']);
cetak_kolom(buku_judul($r['judul']));
cetak_kolom($r['callnumber']);
cetak_kolom($r['isbn']);
cetak_kolom($r['npengarang']);
cetak_kolom($r['npenerbit']);
cetak_kolom($r['cek']);
cetak_kolom($r['note']);
// End of Row data (10): Udah :)
$tx=$dcMarginL;
$gy=$ny+$my;
$pdf->Line($tx,$ny,$tx,$gy);
for($l=0;$l<$i;$l++){
<?php
$row=0; $kol=0; $nkol=5; $fkey=''; $lkey=''; $nb=0;
echo '<table cellspacing="0" cellpadding="0" style="border:10px solid #eebd46;box-shadow:0px 4px 10px rgba(0,0,0,0.5);" width="840px"><tr><td>';
echo '<div style="width:820px;height:600px;max-height:600px;overflow-y:scroll;background:url(\''.IMGR.'/shelfbg.png\');">';
echo '<div style="height:100%;width:100% !important;">';
echo '<table cellspacing="0" cellpadding="0" width="100%">';
while($r=mysql_fetch_array($t)){
if($kol==0){
echo '<tr style="height:172px;background:url(\''.IMGR.'/shelfbg.png\')">';
$fkey=str_firstword($r['judul']);
}
//if($r['replid']==4) $r['replid']=0;
echo '<td style="background:" width="'.(100/$nkol).'%">';
photof($r['replid'],'katalog',buku_judul($r['judul']),$r['npengarang']); $nb++;
echo '</td>';
$lkey=str_firstword($r['judul']);
$kol++;
if($kol==$nkol){
echo '</tr>';
echo '</tr>';
echo '<tr style="height:20px;background:#eebd46">';
echo '<td colspan="'.$nkol.'"><span style="box-shadow:0px 2px 4px rgba(0,0,0,0.4);color:#000;background:#fff;padding:2px 4px;border-radius:2px;font:10px '.SFONT.'"><b>'.$fkey.' - '.$lkey.'</b></span></td>';
echo '</tr>';
$kol=0;
$fkey='';
$row++;
}
}
}
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
//$fform->notif($q);
} else {
if ($opt == 'uf') {
$fform->reg['title_uf'] = 'Pengembalian';
$fform->reg['btnlabel_u_n'] = 'Tidak';
$fform->reg['btnlabel_d_y'] = ' Ya ';
$fform->title_style = 'background:#00c804;color:#fff;height:18px !important;padding:5px 10px 10px 10px !important;margin-bottom:5px';
$fform->head();
$db = new xdb("pus_peminjaman");
$db->field('pus_peminjaman:*', 'pus_buku:barkode', 'pus_katalog:judul');
$db->join('buku', 'pus_buku');
$db->joinother('pus_buku', 'katalog', 'pus_katalog', 'replid');
$db->where("pus_peminjaman.replid='{$cid}'");
$t = $db->query();
$r = mysql_fetch_array($t);
$fform->fc('Kembalikan item berikut ini?');
$fform->fr('Judul', '<b>' . buku_judul($r['judul']) . '</b>');
$fform->fr('Barkode', '<b>' . $r['barkode'] . '</b>');
hiddenval('buku_id', $r['buku']);
hiddenval('status', 0);
hiddenval('tanggal3', date("Y-m-d"));
$fform->foot();
}
}
$t=mysql_query("SELECT pus_buku.replid,pus_buku.barkode,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='$buku'");
//log_print("stocktake_cek: SELECT pus_buku.barkode,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='$buku'");
$r=mysql_fetch_array($t);
echo $r['replid']."`".$r['barkode']." : ".buku_judul($r['judul']);
} else {
echo "2";
}
} else {
echo "1";
}
}
else if($opt=='cekbuku'){
$cid=gpost('cid');
$tbl=stocktake_ctable();
$ts=date("Y-m-d H:i:s");
$q=mysql_query("UPDATE ".$tbl." SET cek='Y',ts='$ts' WHERE buku='$cid'");
if($q){
$t=mysql_query("SELECT pus_buku.barkode,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='$cid'");
$r=mysql_fetch_array($t);
echo $ts.": ".$r['barkode']." : ".buku_judul($r['judul']).", sudah dicek.".chr(13);
} else {
echo $ts.": ".$r['barkode']." : ".buku_judul($r['judul']).", gagal.".chr(13);
}
$ncek_y=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='Y'"));
$ncek=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl));
$w=intval($ncek_y*400/$ncek);
echo "`".$ncek_y."`".$ncek."`".$w."px";
}
else {
}
echo '<button class="btn" title="Tambah data koleksi." style="float:left;margin-right:4px" onclick="katalog_buku_form(\'af\')"><div class="bi_add">Koleksi</div></button>';
echo '<button class="btn" title="Reload." style="float:left;margin-right:4px" onclick="katalog_buku_get()"><div class="bi_relb"> </div></button>';
} else {
echo '<button class="btn" title="Reload." style="float:left;margin-right:4px" onclick="katalog_buku_get()"><div class="bi_relb"> </div></button>';
echo '<div class="warnbox">Perubahan katalog tidak dapat dilakukan selama proses stock opname berlangsung.</div>';
}
$xtable->btnbar_end();
hiddenval('opf', 'buk');
?>
<div class="tbltopmbar" style="float:left;margin-top:10px;margin-bottom:10px">
<table class="stable" cellspacing="0" cellpadding="0" width="100%"><tr valign="top">
<td width="400px">
<table class="stable" cellspacing="0" cellpadding="0">
<tr height="24px"><td colspan="2"><b>Informasi Katalog:</b></td></tr>
<tr height="24px"><td width="140px">Judul:</td><td><?php
echo buku_judul($rk['judul']);
?>
</td></tr>
<tr height="24px"><td width="140px">Klasifikasi:</td><td><?php
echo klasifikasi_name($rk['klasifikasi']);
?>
</td></tr>
<tr height="24px"><td width="140px">Pengarang:</td><td><?php
echo pengarang_name($rk['pengarang']);
?>
</td></tr>
<tr height="24px"><td width="140px">Penerjemah:</td><td><?php
echo $rk['penerjemah'];
?>
</td></tr>
<tr height="24px"><td width="140px">Editor:</td><td><?php
$pubinfo=$r['kota'];
if($pubinfo!='')$pubinfo.=' : ';
$pubinfo.=$r['n3'];
if($r['n3']!='')$pubinfo.=', ';
$pubinfo.=$r['tahunterbit'];
$des='';
if($r['deskripsi']!=''){
$des.='<br/><br/>';
$des.=strtoupper(str_firstword($r['deskripsi'])).'<br/><br/>'.$r['deskripsi'];
}
echo '<table cellspacing="0px" cellpadding="0">',
'<tr valign="top">',
'<td width="70px" style="font:11px '.MSTYPEFONT.'">',$r['kode'],'<br/>',strtoupper(substr($r['n2'],0,3)),'<br/>',strtolower(substr($r['judul'],0,1)),'</td>',
'<td style="font:11px '.MSTYPEFONT.'"><br/>',$r['n2'],'<br/><br/>',buku_judul($r['judul']),' / ',$r['n2'],' -- ',$pubinfo,'<br/><br/>',$r['halaman'],' Hlm<br/><br/>ISBN ',$r['isbn'],$des,'</td>',
'</tr>',
'</table>';
echo '</td></tr></table></a></td>';
$cols++; $n++;
if($cols==$ncols){
$cols=0;
$rows++;
echo '</tr>';
}
}
if($cols<$ncols){
for($i=$cols;$i<$ncols;$i++){
