$PSBar->end();
hiddenval('kriteria', $krit);
kriteria_warn(0, 'float:left');
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
$t = mysql_query("SELECT psb_calonsiswa.*,aka_kelas.replid as idkelas, aka_kelas.kelas as nkelas,aka_tingkat.replid as idtingkat FROM psb_calonsiswa LEFT JOIN aka_kelas ON aka_kelas.replid=psb_calonsiswa.kelas LEFT JOIN aka_tingkat ON aka_tingkat.replid=aka_kelas.tingkat WHERE psb_calonsiswa.status='1' " . ($pros == 0 ? "" : " AND psb_calonsiswa.proses='{$pros}' ") . ($kel == 0 ? "" : " AND psb_calonsiswa.kelompok='{$kel}'") . ($krit == 0 ? "" : " AND psb_calonsiswa.kriteria='{$krit}' ") . " ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
$xtable->optw = '40px';
$xtable->head('No Pendaftaran', 'Nama', 'Kelas~C');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nopendaftaran'], 100);
$xtable->td($r['nama']);
$k = $r['idkelas'] != 0 ? '<a class="linkb" href="javascript:void(0)" onclick="penempatan_kelas_get(' . $r['idkelas'] . ',' . $r['idtingkat'] . ')" title="Tampilkan kelas ' . $r['nkelas'] . '">' . $r['nkelas'] . '</a>' : '';
$xtable->td($k, 100, 'c');
if (admin_isoperator() && $r['idsiswa'] == 0) {
$s = '<button class="btn" title="Tempatkan siswa" onclick="penempatan_form(\'af\',<id>)"><div class="bi_arrow2b"> </div></button>';
} else {
$s = '<div style="height:23px;width:20px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Belum ada calon siswa yang diterima pada kelompok penerimaan ini.');
}
<?php
require_once MODDIR . 'xtable/xtable.php';
$fmod = 'pendataan_saudara';
$xtable = new xtable($fmod);
$xtable->row_strip = false;
// Query
$sql = "SELECT * FROM psb_tmp_saudara WHERE sesid='" . session_id() . "' ORDER BY replid";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
$xtable->begin();
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$s = '<div class="psf12200">Nama: <b>' . $r['nama'] . '</b></div>';
if ($r['tgllahir'] != '0000-00-00') {
$s .= '<div class="psf12200">Tanggal lahir: ' . fftgl($r['tgllahir']) . '</div>';
}
if ($r['sekolah'] != '') {
$s .= '<div class="psf12200">Sekolah: ' . $r['sekolah'] . '</div>';
}
$xtable->td($s);
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
}
$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);
$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>');
if (count($departemen) > 0) {
// Query
$sql = "SELECT * FROM aka_ruang WHERE departemen='{$dept}'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
$t = mysql_query($sql . $xtable->pageorder_sql('kode', 'nama'));
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
$PSBar->end();
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Kode Ruang', '@Nama Ruang', 'Keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kode'], 100);
$xtable->td($r['nama'], 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
} else {
departemen_warn();
}
$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');
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'] == '' ? ' ' : nl2br($r['keterangan']));
$xtable->row_end();
}
$xtable->foot();
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){
// Table head
$xtable->head('@barkode','@judul','@Cek~C','@Waktu cek');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$t1=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='".$r['buku']."'");
//echo
$r1=mysql_fetch_array($t1);
$xtable->td($r['barkode'],120);
$xtable->td(buku_judul($r['judul']));
$s='<span style="color:'.($r['cek']=='Y'?'':'#ff0000').'"><b>'.$r['cek'].'</b></span>';
$xtable->td($s,40,'c');
$d=explode(" ",$r['ts']);
if($r['cek']=='Y') $xtable->td(fftgl($d[0])." - ".$d[1],160);
else $xtable->td('-',160);
$xtable->row_end();}$xtable->foot();
}else{$xtable->nodata();}
echo '</div></td></tr>';
$fform->foot(1,0);
?>
$xtable->btnbar_help();
?>
</div>
<?php
notifbox();
if ($xtable->ndata > 0) {
// Table head
$xtable->head(' ', 'Kelompok', 'tanggal pendaftaran~C', 'Biaya pendaftaran{R}', 'Calon Siswa~C', 'Siswa Diterima~C', 'Keterangan');
$k = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "'");
$n = mysql_num_rows($q);
$q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "' AND status<>0");
$n1 = mysql_num_rows($q);
$xtable->td('<div style="margin:auto;width:14px;height:14px;background:' . $bcolor[$k++] . '"></div>', 20, 'c');
$xtable->td($r['kelompok'], 300);
$xtable->td(fftgl($r['tglmulai']) . (fftgl($r['tglselesai']) != '-' ? '<br/>s/d ' . fftgl($r['tglselesai']) : ''), 180, 'c');
$xtable->td(fRp($r['biaya']), 120, 'r');
$xtable->td($n, 100, 'c');
$xtable->td($n1, 100, 'c');
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
} else {
departemen_warn(1);
$xtable->btnbar_end();
$absensi = array('0' => '', 'h' => 'Hadir', 'a' => 'Abstain', 'i' => 'Ijin', 's' => 'sakit');
if ($xtable->ndata > 0) {
// Table head
$heads = array('@nama');
for ($i = 1; $i <= $dim; $i++) {
$s = '!<div class="presensi_tgl_btn" title="Edit presensi guru tanggal ' . $i . '" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_cm . $i . '\');presensiguru_form(\'af\',0)">' . $i . '</div>';
array_push($heads, $s . '{C,24px}');
}
array_push($heads, '%{C}');
array_push($heads, '{30px,C}');
$xtable->head($heads);
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
//$xtable->td($r['nis'],60);
$xtable->td($r['npegawai']);
$nabsen = 0;
$nhadir = 0;
for ($i = 1; $i <= $dim; $i++) {
$t1 = mysql_query("SELECT absen,keterangan FROM aka_absen_guru WHERE guru='" . $r['replid'] . "' AND tanggal='" . $tgl_cm . $i . "'");
if (mysql_num_rows($t1) > 0) {
$r1 = mysql_fetch_array($t1);
$absen = $r1['absen'];
$info = $r1['keterangan'];
if ($absen != '') {
$nabsen++;
if ($absen == 'H') {
$nhadir++;
}
}
} else {
$lok = gpost('lokasi');
$lokasi = lokasi_r($lok);
$PSBar = new PSBar_2();
// Page selection bar
$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();
exit;
}
$PSBar->end();
$t = mysql_query("SELECT * FROM sar_tempat WHERE lokasi='{$lok}' ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama Tempat', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nama'], 250);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_begin();
//echo iTextSrc('pskeyword',$keyw,'float:left~width:250px','NIS atau nama siswa...',"peminjaman_member_get_siswa(1)");
$xtable->search_box();
$xtable->btnbar_end();
$t = mysql_query("SELECT * FROM aka_siswa WHERE kelas='{$kls}' " . ($keyw == "" ? "" : " AND (nama LIKE '%{$keyw}%' OR nis='{$keyw}') ") . " ORDER BY nama");
$xtable->ndata = mysql_num_rows($t);
//$xtable->search_info($keyw,'Hasil pencarian data siswa dengan NIS atau nama "<b>'.$keyw.'</b>".',"E('pskeyword').value='';peminjaman_member_get_siswa(1)");
$xtable->search_info();
if ($xtable->ndata > 0) {
//$xtable->optw='50px';
$xtable->head('!NIS', 'Nama');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td(srcrep($keyw, $r['nis']), 100);
$xtable->td(srcrep($keyw, $r['nama']));
if (admin_isoperator()) {
$s = '<button class="btn" title="Lihat detil" onclick="peminjaman_member_siswa_view(\'' . $r['replid'] . '\')"><div class="bi_srcb"> </div></button> <button class="btn" onclick="pengembalian_member_pilih(' . $r['replid'] . ',1,\'' . $r['nama'] . '\')">Pilih</button>~75px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak data siswa dengan NIS atau nama <b>' . $keyw . '</b> di kelas ini.');
}
}
$xtable->search_info();
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="";
if ($r['jenis'] == JT_CALONSISWA) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_OUTCOME) {
$cl = '#ff1b1b';
} else {
if ($r['jenis'] == JT_UMUM) {
$cl = '#008aff';
} else {
$cl = '';
}
}
}
}
}
$xtable->td(fftgl($r['tanggal']) . '<br/><b><span style="color:' . $cl . '">' . $r['nomer'] . '</span></b>', 110);
$xtable->td(nl2br($r['uraian']), 250);
$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);
$xtable->opt_ud($r['replid']);
}
$xtable->foot();
$db->join("rek", "keu_rekening");
$db->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'");
$db->where_and("keu_rekening.kategorirek='1'");
$db->order("keu_transaksi.tanggal,keu_transaksi.nomer");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
echo '<div class="sfont" style="font-size:13px;float:left;width:1000px;text-align:left;margin-top:20px;margin-bottom:20px;text-align:center">Tahun Buku: ' . $bukutahun['nama'] . '</div>';
if ($xtable->ndata > 0) {
// echo '<div class="sfont" style="font-size:13px;float:left;width:800px;text-align:left;margin-bottom:4px">['.$jd['koderek'].'] '.$jd['nrek'].'</div>';
// Table head
$xtable->head('Tanggal', 'Kode Rekening{C,70px}', 'Nama Perkiraan', 'Nomor Transaksi{70px}', 'Uraian', 'Debet{R,100px}', 'Kredit{R,100px}');
$debet = 0;
$kredit = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td(fhtgl($r['tanggal']), 80);
$xtable->td($r['koderek'], 70, 'c');
$xtable->td($r['nrek'], 120);
$xtable->td($r['nomer'], 120);
$xtable->td($r['uraian']);
$xtable->td(fRp($r['debet'], 0), 100, 'r');
$debet += $r['debet'];
$xtable->td(fRp($r['kredit'], 0), 100, 'r');
$kredit += $r['kredit'];
$xtable->row_end();
}
$xtable->row_begin();
$s = 'style="border-top:2px solid #88d9ff"';
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
$xtable->td('', '', '', $s);
// 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();
}else{
$xtable->nodata_cust('<span style="color:'.CLGREY.'"><i>Belum ada item yang dipilih.</i></span>');
}
echo '</div>';
?>
<?php
$fmod = 'angsuran';
$xtable = new xtable($fmod);
$xtable->btnbar_f('add');
// Query
$sql = "SELECT * FROM psb_angsuran";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
//echo "gpost('page_number')";
$t = mysql_query($sql . $xtable->pageorder_sql('cicilan', 'keterangan'));
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Jumlah angusran (bulan)~C', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['cicilan'], 200, 'c');
$xtable->td($r['keterangan']);
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
// Query
$t = mysql_query("SELECT * FROM aka_tahunajaran WHERE departemen='{$dept}' ORDER BY tglmulai DESC,replid DESC");
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
$PSBar->end();
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Tahun Ajaran', 'Tanggal Mulai', 'Tanggal Akhir', 'Keterangan', 'Status~C');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['tahunajaran'], 200);
$xtable->td(fftgl($r['tglmulai']), 120);
$xtable->td(fftgl($r['tglakhir']), 120);
$xtable->td($r['keterangan']);
if ($r['aktif'] == '1') {
$s = '<button class="btns" title="Klik untuk me-non aktifkan." style="width:85px" onclick="tahunajaran_status_form(\'uf\',' . $r['replid'] . ')">Aktif</button>';
} else {
$s = '<button class="btn" title="Klik untuk mengaktifkan." style="width:85px" onclick="tahunajaran_status_form(\'uf\',' . $r['replid'] . ')">Tidak Aktif</button>';
}
$xtable->td($s, 100, 'c');
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
if ($pel == 0) {
$xtable->head('Mata pelajaran', 'Nama Guru', 'NIP', 'Keterangan');
} else {
$xtable->head('Nama Guru', 'NIP', 'Keterangan');
}
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
if ($pel == 0) {
$xtable->td($r['namapelajaran'], 150);
}
//$xtable->td($r['kode'],50);
$xtable->td($r['nama'], 250);
$xtable->td($r['nip'], 150);
//$xtable->td(statusguru_name($r),150);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
} else {
}
$PSBar->end();
// Query
$sql = "SELECT sar_pengembalian.*,sar_peminjaman.peminjam,sar_peminjaman.tempat,sar_peminjaman.tanggal1,sar_peminjaman.tanggal2,sar_peminjaman.barang,sar_barang.kode,sar_barang.katalog,sar_katalog.nama FROM sar_pengembalian LEFT JOIN sar_peminjaman ON sar_peminjaman.replid=sar_pengembalian.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_peminjaman.lokasi='{$lok}'";
//echo $sql;
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
$xtable->btnbar_f('add');
$xtable->noopt = true;
if ($xtable->ndata > 0) {
// Table head
$xtable->optw = '50px';
$xtable->head('Peminjam', 'Barang', 'Tanggal Peminjaman', 'Jadwal pengembalian', 'Tanggal dikembalikan', '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(fftgl($r['tanggal']), 140);
$xtable->td($r['tempat'], 200);
$xtable->td(nl2br($r['keterangan']));
//$xtable->opt($r['replid'],'<button class="btn" title="Kembalikan barang ini." onclick="peminjaman_kembalikan(<id>)"><div class="bi_inb"> </div></button>~30');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
} else {
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
// Query
$t = mysql_query("SELECT * FROM aka_angkatan WHERE departemen='{$dept}'");
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
$PSBar->end();
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Angkatan', 'Keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['angkatan'], 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
} else {
departemen_warn();
}
if ($r['jenis'] == JT_CALONSISWA) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_UMUM) {
$cl = '#008aff';
} else {
$cl = '';
}
}
}
}
}
}
}
}
$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>';
$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>';
?>
$tajar = gpost('tahunajaran');
$fmod = 'sks_guru_list';
$xtable = new xtable($fmod, 'item', '', 3);
$xtable->search_box_pos('l');
$xtable->search_keyon('kunci=>hrd_pegawai.nip:EQ|hrd_pegawai.nama:LIKE-0,1');
$xtable->pageorder = "hrd_pegawai.nama";
// Query
$db = guru_db();
$db->where_and("aka_guru.pelajaran='{$pel}'");
$db->where_and("aka_guru.tahunajaran='{$tajar}'");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('hrd_pegawai.nama', 'hrd_pegawai.nip'));
//$xtable->search_box('NIP atau nama guru');
if ($xtable->ndata > 0) {
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto">';
$xtable->head('@Nama', '@!NIP', '{44px}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['npegawai']);
$xtable->td($r['nip'], 80);
$s = '<button class="btn" onclick="sks_guru_set(' . $r['replid'] . ',\'' . $r['npegawai'] . '\')">Pilih</button>';
$xtable->td($s, 40, 'c');
$xtable->row_end();
}
$xtable->foot();
echo '</div>';
} else {
$xtable->nodata();
}
$tglSearch = inputDate('tanggal1', $tanggal1);
$tglSearch .= '<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"> sampai </div>';
$tglSearch .= inputDate('tanggal2', $tanggal2);
$tglSearch .= '<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="transaksi_get()">';
$tglSearch .= '<div class="">Tampilkan »</div>';
$tglSearch .= '</button>';
$t .= $tglSearch;
$t .= '</div>';
$xtable->btnbar_f('print', 'srcbox', $t . '<br>', $s);
hiddenval('modul', $modid);
hiddenval('pembayaran', 0);
if ($xtable->ndata > 0) {
$xtable->head('@No pendaftaran', '@Nama', 'Biaya pendaftaran{R}', 'Jumlah dibayar{R}', '@Tanggal pembayaran', '@Status');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nopendaftaran'], 120);
$xtable->td($r['nama']);
$xtable->td(fRp($r['nominal']), 110, 'r');
$xtable->td(fRp($r['jmlbayar']), 110, 'r');
if ($r['lunas'] == '1') {
$s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>';
} else {
$s = '<button class="btn" title="Klik untuk transaksi pembayaran." onclick="E(\'pembayaran\').value=' . $r['replid'] . ';pembayaran_form(\'af\')" style="width:100px">Belum bayar</button>';
}
$xtable->td(fftgl($r['tglbayar']), 140);
$xtable->td($s, 110, 'c');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata_cust('Tidak ditemukan data pembayaran.');
$PSBar->end();
if ($PSBar->pass) {
$xtable->search_box('nis atau nama siswa');
$db = siswa_db_byangkatan($angk);
$db->where_and("!( NOT EXISTS (SELECT aka_siswa_kelas.replid FROM aka_siswa_kelas WHERE aka_siswa_kelas.siswa=aka_siswa.replid AND aka_siswa_kelas.kelas='{$kls}') )");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('aka_siswa.nis', 'aka_siswa.nama'));
if ($xtable->ndata > 0) {
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$xtable->head('@nis', '@nama', '{44px}');
$n = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['nis'], 100);
$xtable->td($r['nama']);
if (admin_isoperator()) {
$s = '<button class="btn" onclick="xtable2_cekall(false);xtable2_sel(' . $n . ');siswa_pendataan_kelas_siswa_form(\'a\',\'0\',true)"">Pilih</button>~40px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$n++;
$xtable->row_end();
}
$xtable->foot();
echo '</div>';
} else {
$xtable->nodata_cust();
}
<?php
$fmod = 'golongan';
$xtable = new xtable($fmod);
$xtable->use_urut('psb_golongan');
// Query
$t = mysql_query("SELECT * FROM psb_golongan ORDER BY urut");
$xtable->ndata = mysql_num_rows($t);
$xtable->btnbar_f('add', 'updn');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama golongan', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['golongan'], 200);
$xtable->td($r['keterangan']);
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
if ($PSBar->pass) {
$xtable->btnbar_begin();
echo iTextSrc('pskeyword', $keyw, 'float:left~width:250px', 'cari barkode atau judul item...', "peminjaman_buku_get_cari(1)", 'onkeyup="peminjaman_buku_get_cari_do(event)"');
$xtable->btnbar_end();
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 {
<?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>.');
}
}
'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(); }
}
?>
$xtable->btnbar_begin();
//echo '<button style="float:left;margin-right:4px" class="btn" title="Reload" onclick="'.$fmod.'_get()"><div class="bi_relb"> </div></button>';
$xtable->search_box();
//$xtable->btnbar_print();
$xtable->btnbar_end();
$xtable->search_info();
$membertipe=array(1=>'Siswa',2=>'Pegawai',3=>'Member luar');
if($xtable->ndata>0){
$xtable->head('@!ID Member','@Nama member','@Jenis member','@Jumlah Item Dipinjam{R,150px}');
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
if($r['mtipe']==1){
$xtable->td($r['nis'],120);
$xtable->td($r['nsiswa']);
}
else if($r['mtipe']==2){
$xtable->td($r['nip'],120);
$xtable->td($r['npegawai']);
} else {
$xtable->td($r['nid'],120);
$xtable->td($r['nmember']);
}
$xtable->td($membertipe[$r['mtipe']],150);
$xtable->td($r['cnt'].' item',150,'r');
}
$xtable->foot();
} else {
}
$PSBar->end();
$xtable->btnbar_begin();
if($SOUF==0) $xtable->btnbar_add('','','Tambah koleksi baru');
$xtable->search_box('Cari barkode');
$xtable->btnbar_end();
$xtable->search_info('data buku dengan barkode "<b>{keyw}</b>"'.($lok==0?'':' pada lokasi '.preg_replace("/\[[^\[\]]+\]/","",$lokasi[$lok])).'.');
if($xtable->ndata>0){
// Table head
$xtable->head('@Barkode','@!Nomor ID','@sumber','@harga~R','@Tanggal diperoleh','@Status','@lokasi','@tingkat');
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
$xtable->td($r['barkode']);
$xtable->td($r['idbuku'],120);
//$xtable->td($r['callnumber'],120);
$xtable->td($r['sumber']==0?'Beli':'Pemberian',100);
$xtable->td($r['satuan'].' '.$r['harga'],80,'r');
$xtable->td(fftgl($r['tanggal']),120);
if($r['status']==1){
$s='Tersedia';
} else {
$s='<table cellspacing="0" cellpadding="0" width="100%"><tr>';
$s.='<td style="border:none"><span class="sfont">Dipinjam</span></td>';
$s.='<td style="border:none" width="24px" align="right"><button title="Tampilkan info peminjam" class="btn"><div class="bi_usr2b"> </div></button></td>';
$s.='</tr></table>';
$s='Dipinjam';
}
//$xtable->td($s,100);
