function calonsiswa_db_byID($id=0,$f=""){ $db=new xdb("psb_calonsiswa"); $db->field("psb_calonsiswa:replid,nopendaftaran,nama,proses,kelompok".($f==""?"":",".$f),"psb_proses:proses as nproses","psb_kelompok:kelompok as nkelompok"); $db->join("proses","psb_proses"); $db->join("kelompok","psb_kelompok"); //$db->joinother("aka_kelas","tingkat","aka_tingkat"); //$db->joinother("aka_tingkat","tahunajaran","aka_tahunajaran"); //$db->joinother("aka_tahunajaran","departemen","departemen"); $db->where("psb_calonsiswa.replid='$id'"); return $db; }
function siswa_db_byID($id=0,$f=""){ $db=new xdb("aka_siswa_kelas"); $db->field("aka_siswa:replid,nis,nama".($f==""?"":",".$f),"aka_kelas:replid as idkelas,kelas as nkelas","departemen:nama as ndepartemen","aka_angkatan.angkatan as nangkatan"); $db->join("siswa","aka_siswa"); $db->join("kelas","aka_kelas"); $db->joinother("aka_siswa","angkatan","aka_angkatan"); $db->joinother("aka_kelas","tingkat","aka_tingkat"); $db->joinother("aka_tingkat","tahunajaran","aka_tahunajaran"); $db->joinother("aka_tahunajaran","departemen","departemen"); $db->where("aka_siswa.replid='$id'"); return $db; }
function pegawai_db_byID($id=0,$f=""){ $db=new xdb("hrd_pegawai"); $db->field("hrd_pegawai:replid,nip,nama".($f==""?"":",".$f)); $db->where("hrd_pegawai.replid='$id'"); return $db; }
if ($SOUF != 0) { $xtable->noopt = true; } $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();
<?php $ssid = session_id(); require_once MODDIR . 'xtable/xtable.php'; require_once MODDIR . 'control.php'; $fmod = 'peminjaman_buku'; $xtable = new xtable($fmod, 'Item'); $xtable->optw = '50px'; // Query $db = new xdb("pus_tpjm"); $db->field('pus_tpjm:*', 'pus_buku:callnumber,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); $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('!ID Buku', 'Callnumber', 'Judul'); 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['idbuku'], 100); $xtable->td($r['callnumber'], 120); $xtable->td(buku_judul($r['judul'])); $s = '<button class="btn" onclick="peminjaman_buku_form(\'d\',' . $r['replid'] . ')" title="Keluarkan dari daftar"><div class="bi_canb"> </div></button>~30'; $xtable->opt($r['replid'], $s);
} else { $PSBar->end(); hiddenval('kelompok', $kel); kelompok_warn(); exit; } } $PSBar->end(); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'pendataan_form.php'; } else { // Query $xtable->pageorder = "nopendaftaran,nama"; $xtable->search_keyon('nopendaftaran(nomor pendaftaran)=>EQ-0', 'nama-1'); $db = new xdb("psb_calonsiswa"); $db->where("kelompok='{$kel}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('nopendaftaran', 'nama')); $xtable->btnbar_begin(); if ($ncalon < $kapasitas) { $xtable->btnbar_add(); } else { echo '<div class="infobox" style="float:left;margin-left:40px">Kuota periode pendaftaran ini telah penuh.</div>'; } $xtable->btnbar_print(); $xtable->search_box(); $xtable->btnbar_end(); if ($xtable->ndata > 0) { $xtable->head_addrow('@Nomor pendaftaran{2,100px}', '@Nama{2}', 'Uang pangkal{R,2}', 'Discount{C,1,3}', 'Denda{R,2}', 'Uang pangkal net{R,2,90px}', 'Angsuran{R}');
if ($cid == '') { $cid = 0; } $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);
} } // Tabel transaksi $fmod = 'modul_psb'; $xtable = new xtable($fmod, 'Pembayan pendaftaran'); $xtable->pageorder = "psb_calonsiswa.nopendaftaran"; $xtable->search_keyon('nopendaftaran(nomor pendaftaran)=>psb_calonsiswa.nopendaftaran:EQ-0', 'nama=>psb_calonsiswa.nama-1'); $xtable->noopt = true; $xtable->cari = $xtable->keyw == '' ? 0 : 1; // 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">
<?php $ssid=session_id(); require_once(MODDIR.'xtable/xtable.php'); require_once(MODDIR.'control.php'); $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->begin(); $PSBar->selection_departemen($fmod, $dept); $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);
$departemen = departemen_r($dept); if (count($departemen) > 0) { // 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);
if ($SOUF == 0) { $xtable->use_select(); } $xtable->search_keyon('barkode=>pus_buku.barkode:EQ-1'); $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.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);
$PSBar->selection('Kelompok', iSelect('kelompok', $kelompok, $kel, $PSBar->selws, $fmod . "_get()")); } else { $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">
//$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); //$tglsekarang = date("Y-m-d"); $denda = diffDay(date("Y-m-d"),$r['tanggal2']); //$denda1 = diffDay($r['tanggal2'],$r['tanggal1']); if ($denda == 0){ $tdenda = 0; }else { $tdenda = $denda * 200; } $fform->fc('Kembalikan item berikut ini?'); $fform->fr('Judul','<b>'.buku_judul($r['judul']).'</b>'); $fform->fr('Barkode','<b>'.$r['barkode'].'</b>');
$fmod='katalog_buku_daftar'; $xtable=new xtable($fmod,'koleksi'); if($SOUF==0)$xtable->use_select(); $xtable->search_keyon('barkode=>pus_buku.barkode:EQ-1'); $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);
$tbl=stocktake_ctable(); $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');
} } 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(); } }
} else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "siswa='{$cid}'"); $q = dbQSql("UPDATE aka_siswa SET aktif='1' WHERE replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $db = new xdb("aka_mutasi"); $db->field("aka_mutasi:replid,jenismutasi,siswa,tanggal,keterangan", "aka_siswa:nis as snis,nama as ssiswa"); $db->join("siswa", "aka_siswa"); $db->where("aka_mutasi.siswa='{$cid}'"); $r = $db->gofetch(); } else { $r = array(); $r['tanggal'] = date("Y-m-d"); } $fform->dimension(500); $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form $jenismutasi = jenismutasi_opt(); //$fform->fl('Departemen',departemen_name($r['departemen'])); $s = '<button id="mutasi_siswa_btn" title="Cari" class="btn" style="float:left" onclick="mutasi_siswa_formlist()"><div class="bi_srcb"> </div></button>'; $fform->fi('Siswa', iText('snis', $r['snis'], 'float:left;margin-right:4px;width:80px', '', 'readonly', 'onclick="mutasi_siswa_formlist()"') . iText('ssiswa', $r['ssiswa'], 'float:left;margin-right:4px;width:' . ($fform->rwidth - 110) . 'px', '', 'readonly', 'onclick="mutasi_siswa_formlist()"') . $s); hiddenval('siswa', $r['siswa']);
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-0', 'idbuku(nomor ID)=>pus_buku.idbuku:EQ-1', 'judul=>pus_katalog.judul-2', 'callnumber=>pus_katalog.callnumber-3', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-4', 'pengarang(nama pengarang)=>pus_pengarang.nama-5', 'penerbit(nama penerbit)=>pus_penerbit.nama-6'); $db=new xdb('pus_buku'); $db->field('pus_buku:replid,katalog,tingkatbuku,lokasi,barkode,idbuku,status','pus_katalog:judul,klasifikasi,callnumber,pengarang,penerbit','pus_klasifikasi:kode as n1,kode','pus_pengarang:nama as n2','pus_penerbit:nama as n3'); $db->join('katalog','pus_katalog'); $db->join('tingkatbuku','pus_tingkatbuku'); $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($ting==0?"":"pus_buku.tingkatbuku='$ting'"); $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();
$tgl2 = date("Y-m-") . cal_days_in_month(CAL_GREGORIAN, intval(date("m")), intval(date("Y"))); $tanggal1 = gpost('tanggal1', $tgl1); $tanggal2 = gpost('tanggal2', $tgl2); $PSBar = new PSBar_2(100, 450); $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();
if (mysql_num_rows($t) > 0) { $r = mysql_fetch_array($t); $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);
$lokasi=lokasi_r($lok); $tgl1=date("Y-m-")."1"; $tgl2=date("Y-m-").cal_days_in_month(CAL_GREGORIAN,intval(date("m")),intval(date("Y"))); $tanggal1=gpost('tanggal1',$tgl1); $tanggal2=gpost('tanggal2',$tgl2); // 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){
appmod_use('keu/rekening'); $fmod = 'rekening'; $xtable = new xtable($fmod, 'kode rekening'); $xtable->pageorder = "kode"; $kat = gpost('skategorirek'); $kategorirek = kategorirek_r($kat, 1); // Page Selection Bar $PSBar = new PSBar_2(120); $PSBar->begin(); $PSBar->selection('Kategori rekening', iSelect('skategorirek', $kategorirek, $kat, $PSBar->selws, $fmod . "_get()")); $PSBar->end(); // Query $db = new xdb("keu_rekening"); if ($kat !== 0) { $db->where("kategorirek='{$kat}'"); } $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{C}', '@Rekening', 'Keterangan'); $lkat = 0; while ($r = mysql_fetch_array($t)) { $kr = substr($r['kode'], 0, 1); if ($lkat != $r['kategorirek'] && $kat == 0) { $l = strlen($r['kode']) - 1; $xtable->row_begin(); $xtable->td('<b>' . sprintf($kr . "%0" . $l . "d", 0) . '</b>', 100, 'c');