$xtable->usepaggging = false;
$xtable->cari = 0;
$db = new xdb("keu_jurnal");
$db->field("keu_jurnal:*", "keu_rekening:kode as koderek,nama as nrek", "keu_transaksi:tanggal,nomer,uraian");
$db->join("transaksi", "keu_transaksi");
$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();
}
<?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();
}
$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);
$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();
$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>';
?>
$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>';
$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();
}
if (count($pelajaran) > 1) {
$PSBar->selection('Pelajaran', iSelect('spelajaran', $pelajaran, $pel, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('spelajaran', $pel);
pelajaran_warn(0, 'float:left');
$PSBar->pass = false;
}
}
$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 = 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();
}
$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();
}
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
// 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();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($tahunajaran) > 0) {
$PSBar->selection('Tahun ajaran', iSelect('tahunajaran', $tahunajaran, $tajar, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('tahunajaran', $tajar);
tahunajaran_warn(0, 'float:left');
$PSBar->pass = false;
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_f('add', 'updn');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama Penilaian', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['nama'], 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt($r['replid'], 'u', 'd');
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
} else {
departemen_warn();
}
$xtable->btnbar_begin();
echo '<button style="float:left;margin-right:6px" class="btnz" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_c . '\');presensiguru_form(\'af\',0)">Presensi hari ini</button>';
echo '<div class="sfont" style="float:left;margin-top:4px">atau klik pada tanggal utuk mengedit presensi guru.</div>';
$xtable->search_box('nama guru');
$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') {
echo '</tr></table>';
echo '</div>';
echo '<div style="float:left;width:100%;margin-bottom:30px">';
echo inputDate('stanggal1',$stanggal1).'<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"> sampai </div>'.inputDate('stanggal2',$stanggal2).'<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="sirkulasi_get()"><div class="">Tampilkan »</div></button>';
echo '</div>';
$xtable->btnbar_begin();
$xtable->search_box();
//$xtable->btnbar_print();
$xtable->btnbar_end();
$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='-';
$PSBar->pass = false;
}
}
$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.');
//$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();
if ($r['jenis'] == JT_INCOME) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_SISWA) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_CALONSISWA) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_OUTCOME) {
$cl = '#ff1b1b';
} else {
if ($r['jenis'] == JT_UMUM) {
'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(); }
}
?>
hiddenval('lokasi', $lok);
lokasi_warn();
exit;
}
$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();
<?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();
}
<?php
$fmod = 'lokasi';
$xtable = new xtable($fmod, 'Lokasi barang');
$xtable->btnbar_f('add');
// Query
$sql = "SELECT * FROM pus_klasifikasi";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
$t = mysql_query($sql . $xtable->pageorder_sql('kode', 'nama'));
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Kode', '@Nama Klasifikasi', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kode'], 60);
$xtable->td($r['nama'], 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
$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){
// 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();}
$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);
$n++;
$xtable->row_end();}$xtable->foot();
echo '</div>';
} else { $xtable->nodata_cust(); }
}
<?php
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();
//shared/libraries/modules/xtable/xtable.php ::790
$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']);
$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)) {
$xtable->row_begin();
if ($r['jenis'] == JT_INCOME) {
$cl = '#00c804';
} else {
if ($r['jenis'] == JT_OUTCOME) {
$cl = '#ff1b1b';
} else {
if ($r['jenis'] == JT_INBRG) {
$cl = '#ff1b1b';
} else {
if ($r['jenis'] == JT_INBANK) {
$cl = '#00c804';
} else {
$departemen = departemen_r($dept);
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();
$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();
}
$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');
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);
hiddenval('ff_angkatan', $angk);
angkatan_warn(0);
$PSBar->pass = false;
}
$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();
<?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>.');
}
}
lokasi_warn(0, 'float:left');
$PSBar->pass = false;
}
//$PSBar->selection('Cari item',iTextSrc('pskeyword',$keyw,'float:left~width:250px','barkode atau judul item...',"peminjaman_buku_get_cari(1)"));
$PSBar->end();
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);
$PSBar->selection('Periode',inputTanggal('tanggal1',$tanggal1).'<div style="float:left;margin:4px 12px 0px 8px">sampai</div> '.inputTanggal('tanggal2',$tanggal2).$s);
$PSBar->end();
if($PSBar->pass){
$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->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();
}else{
$xtable->nodata_cust('<span style="color:'.CLGREY.'"><i>Belum ada item yang dipilih.</i></span>');
}
