//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">&nbsp</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">&nbsp;</div></button>~30';
        } else {
            $s = '&nbsp;';
        }
        $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>';
Example #2
0
     $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) . '&nbsp;' . 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
Example #3
0
 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'] == '' ? '&nbsp' : nl2br($r['keterangan']));
         $xtable->row_end();
     }
     $xtable->foot();
 } else {
Example #4
0
<?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>');
Example #6
0
$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();
} ?>
Example #7
0
        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'){
Example #8
0
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);
Example #9
0
	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>
Example #10
0
			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++){
Example #11
0
			<?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();
    }
}
Example #13
0
			$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 {
	
}
Example #14
0
    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">&nbsp;</div></button>';
} else {
    echo '<button class="btn" title="Reload." style="float:left;margin-right:4px" onclick="katalog_buku_get()"><div class="bi_relb">&nbsp;</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 
Example #15
0
		$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++){