'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-2', 'pengarang(nama pengarang)=>pus_pengarang.nama:LIKE-3', 'penerbit(nama penerbit)=>pus_penerbit.nama:LIKE-4'); $xtable->pageorder="pus_katalog.judul"; $xtable->rpp=$katalog_view=='list'?$xtable->rpp:21; // Query $db=new xdb("pus_katalog"); $db->field("pus_katalog:replid,judul,klasifikasi,pengarang,penerbit,kota,tahunterbit,halaman,isbn,deskripsi,callnumber","pus_klasifikasi:kode as n1,kode","pus_pengarang:nama as n2,nama2 as nkutip","pus_penerbit:nama as n3","COUNT(pus_buku.replid) as buku_count"); $db->join("replid","pus_buku","katalog"); $db->join("klasifikasi","pus_klasifikasi"); $db->join("pengarang","pus_pengarang"); $db->join("penerbit","pus_penerbit"); $db->where($xtable->search_sql_get()); $db->group("pus_katalog.replid"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('judul','n1','n2','n3','callnumber','buku_count')); $SOUF=stocktake_unfinished(); $xtable->btnbar_begin(); if($SOUF==0) $xtable->btnbar_add(); else echo '<div class="warnbox">Perubahan katalog tidak dapat dilakukan selama proses stock opname berlangsung.</div>'; if($katalog_view=='detil'){ echo '<button title="Tampilan daftar" class="btn" style="float:left;margin-right:4px" onclick="E(\'katalog_view\').value=\'list\';katalog_get()"><div class="bi_lis">Daftar</div></button>'; } else { echo '<button title="Tampilan detil" class="btn" style="float:left;margin-right:4px" onclick="E(\'katalog_view\').value=\'detil\';katalog_get()"><div class="bi_thumb">Detil</div></button>'; }
$xtable->search_box_pos('l'); $xtable->search_keyon('kunci=>pus_member.nid:EQ|pus_member.nama:LIKE-0,1'); /* SELECT aka_siswa.replid, aka_siswa.nis, aka_siswa.nama, COUNT( pus_peminjaman.buku ) AS cnt FROM aka_siswa LEFT JOIN pus_peminjaman ON ( pus_peminjaman.member = aka_siswa.replid AND pus_peminjaman.mtipe = '1' ) GROUP BY aka_siswa.replid */ // Query $db=new xdb('pus_member'); $db->where_and($xtable->search_sql_get()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('pus_member.nid','pus_member.nama')); $xtable->search_box('nomor ID atau nama member'); if($xtable->ndata>0){ echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">'; $xtable->head('@!ID Member','@Nama','{44px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['nid'],80); $xtable->td($r['nama']); if(admin_isoperator()) $s='<button class="btn" onclick="sirkulasi_peminjaman_form_member_set(3,'.$r['replid'].')">Pilih</button>~40px'; else $s='<div style="height:23px;width:40px"></div>';
$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); $xtable->td(buku_judul($r['judul'])); $xtable->td($r['status'] == 1 ? 'Belum dikembalikan' : 'Dikembalikan', 120);
<?php $fmod = 'kelompok'; $xtable = new xtable($fmod, 'kelompok pegawai'); // Query $db = new xdb("hrd_m_kelompok"); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('kelompok')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama kelompok', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['kelompok'], 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
if ($w != "") { $w .= " OR "; } $w .= "keu_transaksi.jenis='" . JT_INBRG . "'"; $sel++; } if ($sel > 0) { // Query $db = new xdb("keu_transaksi"); $db->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'"); $db->where_and("keu_transaksi.tanggal>='{$tanggal1}'"); $db->where_and("keu_transaksi.tanggal<='{$tanggal2}'"); $db->where_and($w == "" ? "" : "(" . $w . ")"); $db->where_and($xtable->search_sql_get()); //$db->order("keu_transaksi.tanggal,keu_transaksi.nomer"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('keu_transaksi.tanggal', 'keu_transaksi.nomer', '', 'keu_transaksi.nominal')); //$t=$db->query($xtable->pageorder_sql('kode','nama')); $xtable->btnbar_begin(); //$xtable->btnbar_print(); //echo '<button class="btn" style="float:left;margin-right:4px" onclick="E(\'pageprinter\').submit()"><div class="bi_pri">Cetak</div></button>'; $xtable->search_box('Cari uraian atau nomor jurnal'); echo iCheckx('ct_jurnaldetil', 'Tampilkan detil jurnal', $ct_jurnaldetil, 'float:right;margin-left:4px;margin-right:30px;margin-top:4px', 'onclick="transaksi_jurnadetil(this.checked)"'); $xtable->btnbar_end(); $xtable->search_info('data transaksi dengan uraian atau nomor jurnal "<b>{keyw}</b>".'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!Tanggal', '@!No. Jurnal / <br/>Jenis Bukti / <br/>No. Bukti', 'Uraian', '@nominal{R' . ($ct_jurnaldetil == 1 ? ',h' : '') . '}', 'Detil Jurnal' . ($ct_jurnaldetil == 1 ? '' : '{h}')); $row = 0; while ($r = mysql_fetch_array($t)) {
// Query $db = new xdb("keu_pembayaran"); $db->field("keu_pembayaran:*", "psb_calonsiswa:nama,nopendaftaran", "keu_transaksi:tanggal as tglbayar,nominal as jmlbayar"); $db->join("siswa", "psb_calonsiswa"); $db->join("modul", "keu_modul"); $db->join("replid", "keu_transaksi", "pembayaran"); $db->where("keu_modul.refid='{$pros}'"); $db->where_and($kel == 0 ? "" : "psb_calonsiswa.kelompok='{$kel}'"); if ($tampil == 'Y') { $db->where_and("keu_pembayaran.lunas='1'"); } if ($tampil == 'N') { $db->where_and("keu_pembayaran.lunas='0'"); } $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql("psb_calonsiswa.nopendaftaran", "psb_calonsiswa.nama", "", "", "keu_transaksi.tanggal", "keu_pembayaran.lunas")); $t = $s = ''; //$s.='<button title="Tampilkan." class="btn" style="float:right;margin-left:4px" onclick="stocktake_note()"><div class="bi_relb"> </div></button>'; $s .= iSelect('tampil', array('all' => 'Semua', 'Y' => 'Sudah bayar', 'N' => 'Belum bayar'), $tampil, 'float:right;margin-left:4px;margin-right:20px', $fmod . '_get()'); $s .= '<div class="sfont" style="float:right;margin-top:4px;margin-left:4px"> <b>Tampilkan:</b> </div>'; $t .= '<div class="sfont" style="float:left;width:100%;margin-bottom:15px"><b>tanggal:</b>'; $t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(1)" >[hari ini]</a>'; $t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(2)" >[bulan ini]</a>'; $t .= '</div>'; $t .= '<div style="float:left;width:100%;margin-bottom:40px">'; $tglSearch = inputDate('tanggal1', $tanggal1); $tglSearch .= '<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"> sampai </div>';
$PSBar->pass = false; } } $PSBar->end(); if ($PSBar->pass) { $db = new xdb("aka_penilaian"); $db->field("SUM(aka_penilaian.bobot) as tbobot"); $db->where_ands("aka_penilaian:guru='{$gid}',pelajaran='{$pel}',kelas='{$kls}'"); $t1 = $db->query(); $r1 = mysql_fetch_array($t1); $tbobot = $r1['tbobot']; // Query $db = new xdb("aka_penilaian"); $db->field("aka_penilaian:*"); $db->where_ands("aka_penilaian:guru='{$gid}',pelajaran='{$pel}',kelas='{$kls}'"); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql("aka_penilaian:nama,kode,kkm,bobot")); $xtable->btnbar_f('add'); //echo $xtable->ndata; if ($xtable->ndata > 0) { // Table head $xtable->head('@Penilaian', '@Kode{C}', '@bobot penilaian{C}', '!Persentase Bobot{C}', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nama'], 300); $xtable->td($r['kode'], 100, 'c'); //$xtable->td($r['kkm'],100,'c'); $xtable->td($r['bobot'], 120, 'c'); $xtable->td(number_format($r['bobot'] * 100 / $tbobot, 2) . ' %', 120, 'c'); $xtable->td(nl2br($r['keterangan']));
$db->where_and($w1); $db->where_and($w2); $db->where_and($w3); if($xtable->keyn=='memberid' && $xtable->page_search==1){ $db->where_and("!((CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nis WHEN '2' THEN hrd_pegawai.nip ELSE pus_member.nid END) = '".$xtable->keyw."')"); } else if($xtable->keyn=='nama' && $xtable->page_search==1){ if($xtable->keyw=='') $keywo=" = '' "; else $keywo=" LIKE '%".$xtable->keyw."%' "; $db->where_and("!((CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nama WHEN '2' THEN hrd_pegawai.nama ELSE pus_member.nama END) ".$keywo.")"); } else { $db->where_and($xtable->search_sql_get()); } if(!($ct_sel1==0 || $ct_sel2==0 || $ct_sel3==0)){ $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('pus_peminjaman.tanggal1','nsiswa,npegawai,nmember','pus_buku.barkode','pus_katalog.judul','pus_peminjaman.tanggal2','pus_peminjaman.status','pus_peminjaman.tanggal3')); } echo '<table cellspacing="0" cellpadding="0" style="margin-bottom:20px"><tr valign="top"><td width="250px">'; echo '<div class="sfont" style="float:left;width:100%;margin-top:0px;margin-bottom:10px"><b>Tampilkan catatan sirkulasi:</b></div>'; echo '<div style="float:left;width:100%">'; echo '<div style="float:left">'; echo '<table cellspacing="0" cellpadding="0">'; echo '<tr height="24px">', '<td>'.iCheckx('ct_pinjam','masih dipinjam',$ct_pinjam).'</td>', '</tr>'; echo '<tr height="24px">', '<td>'.iCheckx('ct_kembali','sudah dikembalikan',$ct_kembali).'</td>', '</tr>';
$s = '<button title="Tambah tahun kelulusan" class="btn" style="float:left" onclick="alumni_tahunlulus_form(\'af\')"><div class="bi_addb"> </div></button>'; $PSBar->selection('Tahun kelulusan', iSelect('tahunlulus', $tahunlulus, $tlulus, 'float:left;margin-right:4px;width:' . (intval($PSBar->selw) - 28) . 'px', $fmod . "_get()") . $s); if (count($tahunlulus) == 0) { $PSBar->pass = false; } $PSBar->end(); if ($PSBar->pass) { // Query $db = new xdb("aka_alumni"); $db->field("aka_alumni:replid,siswa as idsiswa,keterangan", "aka_siswa:nisn,nama", "departemen:nama as ndepartemen", "aka_angkatan:angkatan as nangkatan"); $db->join("siswa", "aka_siswa"); $db->joinother("aka_siswa", "angkatan", "aka_angkatan"); $db->joinother("aka_angkatan", "departemen", "departemen"); $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->search_keyon('kunci=>hrd_pegawai.nip:EQ|hrd_pegawai.nama:LIKE-0,1'); /* SELECT aka_siswa.replid, aka_siswa.nis, aka_siswa.nama, COUNT( pus_peminjaman.buku ) AS cnt FROM aka_siswa LEFT JOIN pus_peminjaman ON ( pus_peminjaman.member = aka_siswa.replid AND pus_peminjaman.mtipe = '1' ) GROUP BY aka_siswa.replid */ // Query $db=new xdb('hrd_pegawai'); $db->field("hrd_pegawai:replid,nip,nama"); $db->where_and($xtable->search_sql_get()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('hrd_pegawai.nip','hrd_pegawai.nama')); $xtable->search_box('nip atau nama member'); if($xtable->ndata>0){ echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">'; $xtable->head('@!ID Member','@Nama','{44px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['nip'],80); $xtable->td($r['nama']); if(admin_isoperator()) $s='<button class="btn" onclick="sirkulasi_peminjaman_form_member_set(2,'.$r['replid'].')">Pilih</button>~40px'; else $s='<div style="height:23px;width:40px"></div>';
<?php $fmod = 'tingkat'; $xtable = new xtable($fmod, 'tingkat pegawai'); // Query $db = new xdb("hrd_m_tingkat"); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('tingkat')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama Tingkat', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['tingkat'], 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
// Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); $PSBar->end(); if ($PSBar->pass) { // Query $db = new xdb("aka_mutasi"); $db->field("aka_mutasi:replid,siswa as idsiswa,tanggal,keterangan", "aka_jenismutasi.nama as njenis", "aka_siswa:nisn,nama", "departemen:nama as ndepartemen", "aka_angkatan:angkatan as nangkatan"); $db->join("siswa", "aka_siswa"); $db->join("jenismutasi", "aka_jenismutasi"); $db->joinother("aka_siswa", "angkatan", "aka_angkatan"); $db->joinother("aka_angkatan", "departemen", "departemen"); $db->where("aka_angkatan.departemen='{$dept}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('aka_mutasi.tanggal', 'aka_siswa:nisn,nama', 'aka_jenismutasi.nama')); $xtable->btnbar_f('add', 'print', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@tanggal', '@!NISN', '@nama', '@jenis mutasi', '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(fftgl($r['tanggal']), 120); $xtable->td($r['nisn'], 80); $xtable->td($r['nama'], 300); $xtable->td($r['njenis'], 100); $xtable->td(nl2br($r['keterangan']));
$PSBar->end(); hiddenval('kelompok', $kel); kelompok_warn(); exit; } $PSBar->end(); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'pendataan_form.php'; } else { $xtable->pageorder = "nopendaftaran,nama"; $xtable->search_keyon('nopendaftaran(nomor pendaftaran)=>EQ-0', 'nama-1'); // Query $db = new xdb("psb_calonsiswa"); $db->where("proses='{$pros}' AND kelompok='{$kel}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $xtable->opt_w = '50px'; $t = $db->query($xtable->pageorder_sql('nopendaftaran', 'nama')); $xtable->btnbar_begin(); ?> <div style="padding-top:4px;float:left;margin-right:10px"><b>Kuota:</b> <?php echo $nsiswa . ' dari ' . $kapasitas; ?> siswa</div> <div style="float:left;border:1px solid #01a8f7;height:4px;width:<?php echo $barw; ?> px;margin-right:4px;margin-top:10px;margin-bottom:4px;position:relative"> <div style="position:absolute;top:0px;left:0px;background:#38ec00;height:4px;width:<?php echo $wsiswa;
$xtable->pageorder="pus_buku.barkode"; if($SOUF!=0)$xtable->noopt=true; $kat=gpost('katalog',0); $lok=gpost('lokasi'); $lokasi=lokasi_r($lokasi,1); $db=new xdb("pus_buku"); $db->field("pus_buku.*","pus_lokasi:nama as nlokasi","pus_tingkatbuku:nama as ntingkat"); $db->join("lokasi","pus_lokasi"); $db->join("tingkatbuku","pus_tingkatbuku"); $db->where("pus_buku.katalog='$kat'"); $db->where_and($xtable->search_sql_get()); if($lok!=0) $db->where_and("pus_buku.lokasi='$lok'"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_buku.idbuku','pus_buku.callnumber','pus_buku.sumber','pus_buku.harga','pus_buku.tanggal','pus_buku.status','nlokasi','ntingkat')); // Page Selection Bar $PSBar = new PSBar_2(100); $PSBar->begin(); if(count($lokasi)>0){ $PSBar->selection('Lokasi',iSelect('lokasi',$lokasi,$lok,$PSBar->selws,$fmod."_get()")); } else { $PSBar->end(); hiddenval('lokasi',$lok); lokasi_warn(0,'float:left'); $PSBar->pass=false; } $PSBar->end();
<?php $fmod = 'status'; $xtable = new xtable($fmod, 'status pegawai'); // Query $db = new xdb("hrd_m_status"); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('status')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama status', 'Reminder', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['status'], 200); $xtable->td($r['reminder'] . ' hari', 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
$pemb = pembayaran_getdatabysubj($modul, $siswaid); $fmod = 'pembayaran'; $xform = new xform($fmod); $xform->table_begin(); $xform->col_begin(); $xtable = new xtable($fmod, 'pembayaran'); $xtable->row_strip = false; //$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1'); $xtable->search_keyon('cari=>keu_transaksi.nomer:EQ|keu_transaksi.uraian:LIKE-1'); $xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.nomer"; // Query $db = new xdb("keu_transaksi"); $db->where_and("keu_transaksi.pembayaran='" . $pemb['replid'] . "'"); //$db->where_and($xtable->search_sql_get()); //$db->order("keu_transaksi.tanggal,keu_transaksi.nomer"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql()); //$t=$db->query($xtable->pageorder_sql('kode','nama')); $s = '<button style="float:left;margin-right:4px" class="btng" onclick="E(\'jenistransaksi\').value=' . JT_INCOME . ';transaksi_form(\'af\')"> <table cellspacing="0" cellpadding="0"><tr> <td><div style="width:20px;height:20px;background:url(' . IMGR . 'inco.png) center no-repeat;margin-right:6px"></div></td><td><span style="font:bold 11px Verdana,Tahoma;color:#fff;margin-right:4px"><b>Pembayaran</b></span></td> </tr></table> </button>'; $xtable->btnbar_f($pemb['lunas'] == 1 ? '<div class="infobox" style="float:left;margin-right:10px">Pembayaran sudah lunas.</div>' : 'add', 'print'); $xtable->search_info('data transaksi dengan uraian atau nomor "<b>{keyw}</b>".'); if ($xtable->ndata > 0) { // Table head $xtable->head('!Tanggal/<br/>No. Transaksi{110px}', 'Uraian', 'Detil Jurnal'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin();
<?php $fmod = 'posisi'; $xtable = new xtable($fmod, 'posisi pegawai'); // Query $db = new xdb("hrd_m_posisi"); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('posisi')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama posisi', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['posisi'], 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
lokasi_warn(0,'float:left'); $PSBar->pass=false; } $PSBar->end(); if($PSBar->pass){ $xtable->search_box('barkode atau judul item'); $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);
$nkelompok = $r['nama']; } else { $nkelompok = ''; } $xform->table_begin('<div id="box_kelompokbrg_nama" style="float:left;margin-top:2px;margin-left:6px;height:24px">' . $nkelompok . '</div>'); $xform->col_begin(); if ($kelompokbrg != 0) { $fmod = 'inventory_brg'; $xtable = new xtable($fmod, 'barang', '', '', 'inventory'); $xtable->pageorder = "kode"; // Query $db = new xdb("keu_brg"); if ($kat !== 0) { $db->where("kelompokbrg='{$kelompokbrg}'"); } $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('kode', 'nama')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Kode', '@Nama Barang', '@Tanggal diperoleh', '@jumlah barang{100px}', 'Keterangan'); $lkat = 0; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['kode'], 100); $xtable->td($r['nama'], 250); $xtable->td(fftgl($r['tanggal']), 120); $xtable->td($r['unit'] . ' ' . $r['satuan'], 100); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']);
$fmod='stocktake_daftar'; $xtable=new xtable($fmod,'item'); $xtable->noopt=true; $xtable->pageorder="cek,ts"; $xtable->search_box_pos('l'); $xtable->search_keyon('barkode=>'.$tbl.'.barkode:EQ-0'); // Query //$sql="SELECT * FROM ".$tbl." ORDER BY cek,ts"; $db=new xdb($tbl); $db->field($tbl.":*","josh.pus_katalog:judul"); $db->join("buku","josh.pus_buku"); $db->joinother("josh.pus_buku","katalog","josh.pus_katalog"); $db->where($xtable->search_sql_get()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql($tbl.".barkode","josh.pus_katalog.judul",$tbl.".cek,@".$tbl.".barkode",$tbl.".ts")); $ncek_y=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='Y'")); $ncek=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl)); if($ncek_y<$ncek){ echo '<div class="infobox">Item yang sudah di cek : <b>'.$ncek_y.'</b> dari <b>'.$ncek.'</b> item.</div>'; } else { echo '<div class="infobox">Semua item sebanyak <b>'.$ncek.'</b> item sudah dicek.</div>'; } $xtable->search_box('cari barkode'); if($xtable->ndata>0){
$lok = gpost('lokasi'); $lokasi = lokasi_r($lok, 1); $jen = gpost('jenisbuku'); $jenisbuku = jenisbuku_r($jen, 1); // Query $xtable->search_keyon('barkode=>pus_buku.barkode:EQ-0', 'judul=>pus_katalog.judul-1', 'callnumber=>pus_buku.callnumber-2', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-3', 'pengarang(nama pengarang)=>pus_pengarang.nama-4', 'penerbit(nama penerbit)=>pus_penerbit.nama-5'); $db = new xdb('pus_buku'); $db->field('pus_buku:replid,katalog,lokasi,barkode,idbuku,callnumber,status', 'pus_katalog:judul,klasifikasi,pengarang,penerbit', 'pus_klasifikasi:kode as n1,kode', 'pus_pengarang:nama as n2', 'pus_penerbit:nama as n3'); $db->join('katalog', 'pus_katalog'); $db->joinother('pus_katalog', 'klasifikasi', 'pus_klasifikasi'); $db->joinother('pus_katalog', 'pengarang', 'pus_pengarang'); $db->joinother('pus_katalog', 'penerbit', 'pus_penerbit'); $db->where($lok == 0 ? "" : "pus_buku.lokasi='{$lok}'"); $db->where_and($jen == 0 ? "" : "pus_katalog.jenisbuku='{$jen}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('barkode', 'judul', 'callnumber', 'n1', 'n2', 'n3', 'status')); // Page Selection Bar $PSBar = new PSBar_2(100); $PSBar->begin(); if (count($lokasi) > 0) { $PSBar->selection('Lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('lokasi', $lok); hiddenval('jenisbuku', $jenb); lokasi_warn(); $PSBar->pass = false; } if ($PSBar->pass) {
$PSBar->begin(); $s = '<button style="float:left;margin:0px 4px 0px 4px" class="btn" title="Tampilkan" onclick="' . $fmod . '_get()"><div class="bi_srcb"> </div></button>'; $PSBar->selection('Periode', inputTanggal('tanggal1', $tanggal1) . ' <div style="float:left;margin:4px 8px 0px 8px">sampai</div> ' . inputTanggal('tanggal2', $tanggal2) . $s); $PSBar->end(); // Query $db = new xdb("pus_peminjaman"); $db->field("pus_peminjaman:*", "pus_buku:barkode", "pus_katalog:judul", "DATEDIFF(pus_peminjaman.tanggal3,pus_peminjaman.tanggal2) as telat", "aka_siswa:nis,nama as nsiswa", "hrd_pegawai:nip,nama as npegawai"); $db->join("buku", "pus_buku"); $db->join("member", "aka_siswa"); $db->join("member", "hrd_pegawai"); $db->joinother("pus_buku", "katalog", "pus_katalog"); $db->where("pus_peminjaman.status = '0'"); $db->where_and("pus_peminjaman.tanggal3 >= '{$tanggal1}'"); $db->where_and("pus_peminjaman.tanggal3 <= '{$tanggal2}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('barkode', 'judul', 'nsiswa,npegawai', 'tanggal1', 'tanggal2', 'tanggal3', 'telat')); $xtable->btnbar_begin(); if ($SOUF == 0) { $xtable->btnbar_add(); } else { echo '<div class="warnbox">Pengembalian tidak dapat dilakukan selama proses stock opname berlangsung.</div>'; } $xtable->search_box(); //$xtable->btnbar_print(); $xtable->btnbar_end(); $xtable->search_info(); if ($xtable->ndata > 0) { // Table head $xtable->head('@Barkode Item', '@Judul Item', '@Peminjam', '@Tgl peminjaman', '@Tgl pengembalian', '@Tgl dikembalikan', '@Terlambat{R}', 'Keterangan');
$xtable->tbl_style = 'float:left;margin-bottom:30px'; $xtable->row_strip = false; $xtable->usepaggging = false; $xtable->cari = 0; $db_out = new xdb("keu_jurnal"); $db_out->field("keu_jurnal:*", "keu_rekening:kode as koderek,nama as nrek", "keu_transaksi:tanggal,nomer,uraian"); $db_out->join("transaksi", "keu_transaksi"); $db_out->join("rek", "keu_rekening"); $db_out->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'"); $db_out->where_and("keu_jurnal.rek='{$rek}'"); $db_out->where_and("keu_transaksi.tanggal >= '{$tanggal1}'"); $db_out->where_and("keu_transaksi.tanggal <= '{$tanggal2}'"); $db_out->where_and("keu_jurnal.debet = '0'"); $db_out->where_and($fct == "" ? "" : "(" . $fct . ")"); $db_out->order("keu_transaksi.tanggal,keu_transaksi.nomer"); $t = $db_out->query(); $xtable->ndata = mysql_num_rows($t); // Table head $xtable->head('Tanggal', 'Nomor Transaksi{120px}', 'Uraian', 'Nominal{R}'); if ($xtable->ndata > 0) { while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td(fhtgl($r['tanggal']), 80); $xtable->td($r['nomer'], 120); $xtable->td($r['uraian']); $xtable->td(fRp($r['kredit'], 0), 100, 'r'); $kredit += $r['kredit']; $xtable->row_end(); } } else { $xtable->row_begin();
// Query $xtable->search_keyon('memberid(ID member)=>aka_siswa.nis:EQ|hrd_pegawai.nip:EQ|pus_member.nid:EQ-0','nama(nama member)=>aka_siswa.nama:LIKE|hrd_pegawai.nama:LIKE|pus_member.nama:LIKE-1'); $db=new xdb("pus_peminjaman"); $db->field("pus_peminjaman:replid,member,mtipe","COUNT(pus_peminjaman.member) as cnt","aka_siswa:nis,nama as nsiswa","hrd_pegawai:nip,nama as npegawai","pus_member:nid,nama as nmember"); $db->join("buku","pus_buku"); $db->join("member","aka_siswa"); $db->join("member","hrd_pegawai"); $db->join("member","pus_member"); $db->where($lok==0?"":"pus_buku.lokasi='$lok'"); $db->where_and("pus_peminjaman.tanggal1 >= '$tanggal1'"); $db->where_and("pus_peminjaman.tanggal1 <= '$tanggal2'"); $db->where_and($xtable->search_sql_get()); $db->group("pus_peminjaman.mtipe,pus_peminjaman.member"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('nis,nip,nid','nsiswa,npegawai,nmember','mtipe','cnt')); // Page Selection Bar $PSBar = new PSBar_2(100,450); $PSBar->begin(); $PSBar->selection('Statistik',iSelect('statistik',$statistik,$stat,$PSBar->selws,$fmod."_get()")); if(count($lokasi)>0){ $PSBar->selection('Lokasi',iSelect('lokasi',$lokasi,$lok,$PSBar->selws,$fmod."_get()")); } else { $PSBar->end(); hiddenval('lokasi',$lok); lokasi_warn(0,'float:left'); $PSBar->pass=false;
<?php $fmod = 'bagian'; $xtable = new xtable($fmod, 'divisi pegawai'); // Query $db = new xdb("hrd_m_bagian"); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('bagian')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama divisi', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['bagian'], 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }