//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>';
'penerbit'=>"pus_penerbit.nama:LIKE")); $sql="SELECT ".$f." FROM pus_katalog ".$j." ".$xtable->search_sql_get(); $t=mysql_query($sql); $xtable->ndata=mysql_num_rows($t); $t=mysql_query($sql.$xtable->pageorder_sql('judul','n1','n2','n3')); $xtable->btnbar_begin(); $xtable->btnbar_add(); $xtable->search_box(); //$xtable->btnbar_print(); $xtable->btnbar_end(); $xtable->search_info(); if($xtable->ndata>0){ // Table head $xtable->head('@Title','@Classification','@Author','@Publisher'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['judul'],0,'','judul'); $xtable->td(klasifikasi_name($r['klasifikasi']),200,'','kode'); $xtable->td($r['n2'],120,'','pengarang'); $xtable->td($r['n3'],120,'','penerbit'); $s='<button class="btn" title="Add new item" onclick="PCBCODE=201;katalog_form_view(\''.$r['replid'].'\')"><div class="bi_add">Item</div></button>~60'; $xtable->opt($r['replid'],'v','u','d',$s); $xtable->row_end();}$xtable->foot(); } else { $xtable->nodata(); } } ?>
<?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>.'); } }
$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(); }
} } } $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.'); }
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','@!Nomor Induk','@Judul','@Callnumber','@Klasifikasi','@Pengarang','@Penerbit','@Status'); while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']); $xtable->td($r['barkode'],120); $xtable->td($r['idbuku'],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').'.'); } } ?>
require_once MODDIR . 'xtable/xtable.php'; require_once MODDIR . 'control.php'; $fmod = 'peminjaman_tabelcari'; $xtable = new xtable($fmod); $xtable->tblstyle = 'float:default'; $keyword = gpost('keyword'); if ($keyword != '') { // Query $sql = "SELECT sar_peminjaman.*,sar_barang.kode,sar_katalog.nama FROM sar_peminjaman LEFT JOIN sar_barang ON sar_barang.replid=sar_peminjaman.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); //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="pengembalian_setpeminjaman(<id>)"><div class="bi_in">Proses</div></button>'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata_cust('Tidak ditemukan barang dengan kode atau nama <b>' . $keyword . '</b> yang dipinjam.'); } echo '</div>'; //echo '</textarea>'; }
$db->where("aka_alumni.tahunlulus='{$tlulus}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('nisn', 'nama', 'angkatan')); $xtable->btnbar_f('add', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!NISN', '@nama', '@angkatan{C}', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); //$t1=dbQSql("SELECT * FROM aka_siswa WHERE replid='".$r['siswa']."' LIMIT 0,1"); //$r1=dbFA($t1); //$xtable->td($r['nis'],80); $xtable->td($r['nisn'], 120); $xtable->td($r['nama'], 300); $xtable->td($r['nangkatan'], 80, 'c'); $xtable->td(nl2br($r['keterangan'])); //$xtable->td($r['tmplahir'].', '.fftgl($r['tgllahir']),100); //$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_pendataan_kelas_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>'; $xtable->opt($r['idsiswa'], 'u', 'd'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } } } else { departemen_warn(); }
$PSBar->end(); if ($PSBar->pass) { $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->optw = '50px'; $xtable->head('Peminjam', 'Barang', 'Tanggal Peminjaman', 'Tanggal pengembalian', 'Tempat Peminjaman', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['peminjam'], 120); $xtable->td('Kode: <b>' . $r['kode'] . '</b><br/ >Nama barang: ' . $r['nama'], 250); $xtable->td(fftgl($r['tanggal1']), 140); $xtable->td(fftgl($r['tanggal2']), 140); $xtable->td($r['tempat'], 200); $xtable->td(nl2br($r['keterangan'])); if ($r['status'] == 1) { $xtable->opt($r['replid'], '<button class="btn" title="Kembalikan barang ini." onclick="PCBCODE=-1;openPage(' . app_page_getindex('pengembalian') . ',\'pengembalian\',false,\'peminjaman=<id>\')"><div class="bi_inb"> </div></button>~30'); } else { $xtable->td(' '); } $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } } } } else { lokasi_warn(); }
// 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>'; }