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;
}
$cid = gpost('cid');
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');
$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);
$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();
$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');
<?php $ssid=session_id(); require_once(MODDIR.'xtable/xtable.php'); require_once(MODDIR.'control.php');
$fmod='sirkulasi_pengembalian_form_buku';
$xtable = new xtable($fmod,'Item','',2);
$xtable->pageorder='pus_tpjm.replid DESC';
// Query
$db=new xdb("pus_tpjm");
$db->field('pus_tpjm:replid','pus_peminjaman:tanggal1,tanggal2','pus_buku:barkode,idbuku','pus_katalog:judul');
$db->join('peminjaman','pus_peminjaman');
$db->joinother('pus_peminjaman','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','Tgl pengembalian','Terlambat','{44px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
//$xtable->td('<button class="btn" onclick="pengembalian_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']));
$xtable->td(fftgl($r['tanggal2']),110);
$telat=diffDay($r['tanggal2']);
$xtable->td(($telat<0?(-$telat).' hari':'-'),80);
$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();
$xtable->use_select();
}
$xtable->pageorder = "barkode,judul";
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();
$mtipe = 0;
}
$fmod = 'peminjaman';
$xform = new xform($fmod, $opt, $cid);
if ($mtipe != 0) {
$lbls = 'float:left;width:120px;margin-right:4px';
$fs = 'float:left;width:200px;margin-right:4px';
echo '<div style="float:left;margin-right:6px;width:62px;height:92px">';
$xform->photof($cid . '-' . $mtipe, 'member', 60, 90, 'h');
echo '</div>';
echo '<div style="float:left;width:328px">';
if ($mtipe == 1) {
$db = new xdb("aka_siswa", "*", "aka_siswa.replid='{$cid}'");
$db->field('aka_siswa:replid,nis,nama', 'aka_kelas:kelas');
$db->join('replid', 'aka_siswa_kelas', 'siswa');
$db->joinother('aka_siswa_kelas', 'kelas', 'aka_kelas');
$t = $db->query();
$r = mysql_fetch_array($t);
echo '<div class="xrowl">';
echo '<div class="sfont" style="font-size:14px;float:left:margin-right:4px;width:324px"><b>' . $r['nama'] . '</b></div>';
echo '</div>';
echo '<div class="xrowl">';
echo '<div class="sfont" style="' . $lbls . '">ID member:</div>';
echo '<div class="sfont" style="' . $fs . '">' . $r['nis'] . '</div>';
echo '</div>';
echo '<div class="xrowl">';
echo '<div class="sfont" style="' . $lbls . '">Tipe member:</div>';
echo '<div class="sfont" style="' . $fs . '">Siswa</div>';
echo '</div>';
echo '<div class="xrowl">';
echo '<div class="sfont" style="' . $lbls . '">Kelas:</div>';
// Page Selection Bar
$PSBar = new PSBar_2();
$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);
