<?php
require_once MODDIR . 'xtable/xtable.php';
appmod_use('keu/rekening');
$tahunbuku = tahunbuku_getaktifid();
$pemb = pembayaran_getdatabysubj($modul, $siswaid);
$fmod = 'pembayaran';
$xform = new xform($fmod);
$xform->table_begin();
$xform->col_begin();
$xtable = new xtable($fmod, 'pembayaran');
$xtable->row_strip = false;
//$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1');
$xtable->search_keyon('cari=>keu_transaksi.nomer:EQ|keu_transaksi.uraian:LIKE-1');
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.nomer";
// Query
$db = new xdb("keu_transaksi");
$db->where_and("keu_transaksi.pembayaran='" . $pemb['replid'] . "'");
//$db->where_and($xtable->search_sql_get());
//$db->order("keu_transaksi.tanggal,keu_transaksi.nomer");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql());
//$t=$db->query($xtable->pageorder_sql('kode','nama'));
$s = '<button style="float:left;margin-right:4px" class="btng" onclick="E(\'jenistransaksi\').value=' . JT_INCOME . ';transaksi_form(\'af\')">
<table cellspacing="0" cellpadding="0"><tr>
<td><div style="width:20px;height:20px;background:url(' . IMGR . 'inco.png) center no-repeat;margin-right:6px"></div></td><td><span style="font:bold 11px Verdana,Tahoma;color:#fff;margin-right:4px"><b>Pembayaran</b></span></td>
</tr></table>
</button>';
$xtable->btnbar_f($pemb['lunas'] == 1 ? '<div class="infobox" style="float:left;margin-right:10px">Pembayaran sudah lunas.</div>' : 'add', 'print');
$xtable->search_info('data transaksi dengan uraian atau nomor "<b>{keyw}</b>".');
<?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 {
}
<?php
$ssid = session_id();
require_once MODDIR . 'xtable/xtable.php';
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$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">';
<?php
require_once MODDIR . 'control.php';
$fmod = 'ruang';
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$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();
}
<?php
$SOUF = stocktake_unfinished();
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
$keyw = gpost('keyword');
$keyn = gpost('keyon');
$fmod = 'pengembalian';
$xtable = new xtable($fmod, 'pengembalian');
$xtable->noopt = true;
$xtable->pageorder = "pus_peminjaman.tanggal3 DESC";
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-0', 'judul=>pus_katalog.judul:LIKE-1', 'memberid(ID member)=>aka_siswa.nis:EQ|hrd_pegawai.nip:EQ-2', 'nama(nama member)=>aka_siswa.nama:LIKE|hrd_pegawai.nama:LIKE-2');
if ($opt == 'af' || $opt == 'uf') {
require_once VWDIR . 'pengembalian_form.php';
} else {
hiddenval('member_id', 0);
hiddenval('member_tipe', 0);
$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");
$fmod="siswakelas";
$fform=new fform($fmod,'af',$cid,'Cari siswa');
$fform->globalkey='0';
$fform->reg['title_af']='<idata>';
$fform->reg['btnlabel_a_y']='Tutup';
//$fform->reg['btnlabel_a_n']='Tutup';
$fform->dimension(650);
$fform->ptop=30;
$fform->yes_act='close_fform()';
$fform->head('Daftar Pengecekan Item');
echo '<tr><td><div id="data_member" style="height:350px;overflow:auto">';
$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"));
<?php
require_once APPMOD . 'psb/proses.php';
$fmod = 'kelompok';
$xtable = new xtable($fmod, 'kelompok pendaftaran');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$pros = gpost('proses');
$proses = proses_r($pros, $dept);
if (count($departemen) > 0) {
// Query
$sql = "SELECT * FROM psb_kelompok WHERE proses='{$pros}'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
// Page sort and order
$po = $xtable->pageorder_sql('kelompok', 'kapasitas');
$t = mysql_query($sql . $po);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($proses) > 0) {
$PSBar->selection('Periode', iSelect('proses', $proses, $pros, "width:" . $PSBar->selw, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('proses', $pros);
proses_warn();
exit;
}
$PSBar->end();
$bcolor = array("#86c2ff", "#ffb129", "#00fa29", "#ffcf0d", "#00eb27", "#89bc02", "#ff8001");
<?php
require_once MODDIR . 'control.php';
$fmod = 'tahunajaran';
$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>';
<?php
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
$peminjaman = gpost('peminjaman');
if ($peminjaman == '') {
$peminjaman = 0;
}
hiddenval('peminjaman', $peminjaman);
$fmod = 'pengembalian';
$xtable = new xtable($fmod);
$lok = gpost('lokasi');
$lokasi = lokasi_opt($lok);
if (count($lokasi) > 0) {
if ($opt == 'af' || $opt == 'uf') {
require_once VWDIR . 'pengembalian_form.php';
} else {
// Page sort and order
//$po=$xtable->pageorder_sql('peminjam','nama');
//$t=mysql_query($sql.$po);
$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();
<?php
appmod_use('aka/tahunajaran', 'aka/guru', 'aka/presensi');
$opt = gpost('opt');
$cid = gpost('cid', 0);
$fmod = 'presensiguru';
$xtable = new xtable($fmod, 'presensi');
$xtable->noopt = true;
$xtable->search_keyon('nama=>hrd_pegawai.nama:LIKE-0');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$tajar = gpost('tahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
$tanggal = gpost('tanggal');
if ($tanggal == '') {
$tanggal = date("Y-m-d");
}
$tgl = explode("-", $tanggal);
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tgl_f = $tgl[0] . "-" . $tgl[1] . "-1";
$tgl_c = date("Y-m-d");
$tgl_l = $tgl[0] . "-" . $tgl[1] . "-" . $dim;
$tgl_cm = $tgl[0] . "-" . $tgl[1] . "-";
$t0 = date('Y-m-d', strtotime('- 1 day', strtotime($tanggal)));
$t1 = date('Y-m-d', strtotime('+ 1 day', strtotime($tanggal)));
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($tahunajaran) > 0) {
<?php
$fmod = 'tempat';
$xtable = new xtable($fmod);
$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();
}
<?php
appmod_use('aka/tahunajaran');
$fmod = 'tesakademik';
$xtable = new xtable($fmod, 'jenis penilaian');
$xtable->use_urut('aka_tes');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$tajar = gpost('tahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
// Query
$t = mysql_query("SELECT * FROM aka_tes WHERE tahunajaran='{$tajar}' ORDER BY urut");
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$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
if($ct_lain!=0){if($w2!="")$w2.=" OR ";
$w2.="pus_peminjaman.mtipe='3'";
$ct_sel2++;}
$w2=($w2==''||$ct_sel2==3)?'':'('.$w2.')';
$tgl=explode("-",date("Y-m-d")); $dim=cal_days_in_month(CAL_GREGORIAN,intval($tgl[1]),intval($tgl[0]));
$tgl_f=date("Y-m")."-1";
$tgl_c=date("Y-m-d");
$tgl_l=date("Y-m")."-".$dim;
$stanggal1=gpost('stanggal1',$tgl_f);
$stanggal2=gpost('stanggal2',$tgl_l);
hiddenval('tanggal_f',$tgl_f);
hiddenval('tanggal_c',$tgl_c);
hiddenval('tanggal_l',$tgl_l);
$xtable = new xtable($fmod,'peminjaman');
$xtable->pageorder="pus_peminjaman.tanggal1 DESC,pus_peminjaman.replid DESC";
$xtable->search_keyon('barkode=>pus_buku.barkode:EQ-2',
'judul=>pus_katalog.judul:LIKE-3',
'memberid(ID member)=>aka_siswa.nis:EQ|hrd_pegawai.nip:EQ|pus_member.nid:EQ-1',
'nama(nama member)=>aka_siswa.nama:LIKE|hrd_pegawai.nama:LIKE|pus_member.nama:LIKE-1');
// Query
$db=new xdb("pus_peminjaman");
$db->field("pus_peminjaman:*","pus_buku:barkode","pus_katalog:judul","aka_siswa:nis,nama as nsiswa","hrd_pegawai:nip,nama as npegawai","pus_member:nid,nama as nmember");//,"(CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nis WHEN '2' THEN hrd_pegawai.nip ELSE pus_member.nid END) as id_member");//,"@id_member:= as idmmbr");//,"(CASE pus_peminjaman.status='1' AND '".date("Y-m-d")."' > pus_peminjaman.tanggal2 WHEN TRUE THEN '1' ELSE '0' END) as telat1","(CASE pus_peminjaman.status='0' AND pus_peminjaman.tanggal3 > pus_peminjaman.tanggal2 WHEN TRUE THEN '1' ELSE '0' END) as telat2");
$db->join("buku","pus_buku");
$db->join("member","aka_siswa");
$db->join("member","hrd_pegawai");
$db->join("member","pus_member");
$db->joinother("pus_buku","katalog","pus_katalog");
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
require_once MODDIR . 'apps/aka.php';
$fmod = 'peminjaman_member_get_siswa';
$xtable = new xtable($fmod, 'siswa');
$keyw = gpost('keyword');
$xtable->keyw = $keyw;
$xtable->keyph = 'nis atau nama siswa';
$xtable->search_box_pos('l');
$dept = gpost('psdepartemen');
$departemen = departemen_r($dept);
$tajar = gpost('pstahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
$ting = gpost('pstingkat');
$tingkat = tingkat_r($ting, $tajar);
$kls = gpost('pskelas');
$kelas = kelas_r($kls, $ting);
?>
<div class="fftabbar">
<div class="fftab1" onclick="<?php
echo $fmod;
?>
_get(0)">Siswa</div>
<div class="fftab" onclick="siswa_saudara_siswapilih(0)">Pegawai</div>
<div class="fftab" onclick="siswa_saudara_siswapilih(0)">Member luar</div>
</div>
<?php
$PSBar = new PSBar_2(100);
$PSBar->begin();
<?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();
}
$aktiva = 0;
$pasiva = 0;
// Aktiva
echo '<tr height="20px">', '<td style="font-size:11px" ><b>Aktiva :</b></td>', '<td></td>', '<td></td>', '</tr>';
foreach ($rekaktiva as $rek => $r) {
echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekaktiva[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekaktiva[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$aktiva += $rekaktiva[$rek]['nominal'];
}
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Aktiva:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($aktiva, 1, 1, 1) . '</b></td>', '</tr>';
echo '<tr height="10px">', '<td></td>', '<td></td>', '<td></td>', '</tr>';
// pasiva
echo '<tr height="20px">', '<td style="font-size:11px" ><b>Pasiva :</b></td>', '<td></td>', '<td></td>', '</tr>';
foreach ($rekpasiva as $rek => $r) {
echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekpasiva[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekpasiva[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$pasiva += $rekpasiva[$rek]['nominal'];
}
echo '<tr height="20px">', '<td style="font-size:11px" >Laba bersih</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($lababersih, 1, 1, 1) . '</td>', '<td></td>', '</tr>';
$pasiva += $lababersih;
echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total pasiva:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($pasiva, 1, 1, 1) . '</b></td>', '</tr>';
echo '</table>';
} else {
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Tidak ada data transaksi.');
}
} else {
$xtable = new xtable($fmod);
$xtable->nodata_cust('Silahkan pilih laporan transaksi.');
}
<?php
appmod_use('aka/tahunajaran', 'aka/pelajaran');
$fmod = 'guru';
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$tajar = gpost('tahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
$pel = gpost('spelajaran');
$pelajaran = pelajaran_r($pel, $tajar, 1);
// Query
if ($pel == 0) {
$t = mysql_query("SELECT aka_guru.*,hrd_pegawai.nip,hrd_pegawai.nama,aka_pelajaran.nama as namapelajaran FROM aka_guru LEFT JOIN hrd_pegawai ON aka_guru.pegawai=hrd_pegawai.replid LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_guru.pelajaran WHERE aka_guru.tahunajaran='{$tajar}' ORDER BY aka_pelajaran.nama, hrd_pegawai.nama");
} else {
$t = mysql_query("SELECT aka_guru.*,hrd_pegawai.nip,hrd_pegawai.nama FROM aka_guru LEFT JOIN hrd_pegawai ON aka_guru.pegawai=hrd_pegawai.replid WHERE aka_guru.tahunajaran='{$tajar}' AND aka_guru.pelajaran='{$pel}' ORDER BY hrd_pegawai.nama");
}
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$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);
hiddenval('spelajaran', $pel);
tahunajaran_warn(0, 'float:left');
$PSBar->pass = false;
<?php require_once(MODDIR.'control.php'); require_once(MODDIR.'xtable/xtable.php');
$fmod='sirkulasi_peminjaman_form_buku_list';
$xtable=new xtable($fmod,'item','',3);
$xtable->search_keyon('kunci=>pus_buku.barkode:EQ|pus_katalog.judul:LIKE-0,1');
$xtable->search_box_pos('l');
$xtable->pageorder="pus_buku.barkode";
$xtable->use_select();
$xtable->select_noopt=true;
$xtable->select_cekfunc="sirkulasi_peminjaman_form_buku_list_cek(param)";
$lok=gpost('ff2_lokasi');
$lokasi=lokasi_r($lok);
$PSBar = new PSBar_2(100);
$PSBar->begin();
if(count($lokasi)>0){
$PSBar->selection('Lokasi',iSelect('ff2_lokasi',$lokasi,$lok,$PSBar->selws,"peminjaman_buku_get_cari(1)"));
} else {
$PSBar->end();
hiddenval('pslokasi',$lok);
lokasi_warn(0,'float:left');
$PSBar->pass=false;
}
$PSBar->end();
if($PSBar->pass){
$xtable->search_box('barkode atau judul item');
$db=new xdb("pus_buku");
$db->field("pus_buku:replid","pus_buku:barkode","pus_katalog:judul");
$db->join("katalog","pus_katalog");
<?php
require_once MODDIR . 'control.php';
$fmod = 'angkatan';
$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();
<?php
appmod_use('keu/rekening');
$tahunbuku = tahunbuku_getaktifid();
$fmod = 'transaksi';
$xtable = new xtable($fmod);
$xtable->row_strip = false;
//$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1');
$xtable->search_keyon('cari=>keu_transaksi.nomer:EQ|keu_transaksi.uraian:LIKE-1,2');
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.ct";
$tanggal1 = gpost('tanggal1', date("Y-m") . "-1");
$tgl = explode("-", date("Y-m-d"));
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tanggal2 = gpost('tanggal2', date("Y-m") . "-" . $dim);
$ct_jurnaldetil = gpost('ct_jurnaldetil', 1);
$ct_umum = gpost('ct_umum', 1);
$ct_pemasukan = gpost('ct_pemasukan', 1);
$ct_pengeluaran = gpost('ct_pengeluaran', 1);
$ct_siswa = gpost('ct_siswa', 1);
$ct_calonsiswa = gpost('ct_calonsiswa', 1);
$ct_barang = gpost('ct_barang', 1);
$w = "";
$sel = 0;
if ($ct_umum != 0) {
if ($w != "") {
$w .= " OR ";
}
$w .= "keu_transaksi.jenis='" . JT_UMUM . "'";
$sel++;
}
if ($ct_pemasukan != 0) {
<?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>';
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
appmod_use('aka/guru');
$pel = gpost('pelajaran');
$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();
$modul = mysql_fetch_array($t);
$modid = $modul['replid'];
$inp = array('modul' => $modid, 'siswa' => 0, 'nominal' => 0, 'cicilan' => 0);
$t = mysql_query("SELECT psb_calonsiswa.replid,psb_kelompok.biaya FROM psb_calonsiswa LEFT JOIN psb_kelompok ON psb_kelompok.replid=psb_calonsiswa.kelompok WHERE psb_calonsiswa.proses='{$pros}'");
while ($r = mysql_fetch_array($t)) {
$t1 = mysql_query("SELECT * FROM keu_pembayaran WHERE modul='{$modid}' AND siswa='" . $r['replid'] . "'");
if (mysql_num_rows($t1) == 0) {
$inp['siswa'] = $r['replid'];
$inp['nominal'] = $r['biaya'];
$inp['cicilan'] = $r['biaya'];
$q = dbInsert("keu_pembayaran", $inp);
}
}
// 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'");
}
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
appmod_use('aka/angkatan', 'aka/siswa');
$fmod = 'siswa_pendataan_kelas_list';
$xtable = new xtable($fmod, 'siswa', '', 2);
$xtable->search_keyon('kunci=>aka_siswa.nis:EQ|aka_siswa.nama:LIKE-0,1');
$xtable->search_box_pos('l');
$xtable->pageorder = "aka_siswa.nis";
$xtable->use_select();
$xtable->select_noopt = true;
$xtable->select_cekfunc = "siswa_pendataan_kelas_list_cek(param)";
$dept = gpost('ff_departemen');
$departemen = departemen_r($dept);
$angk = gpost('ff_angkatan');
$angkatan = angkatan_r($angk, $dept);
$kls = gpost('kelas');
$PSBar = new PSBar_2(100);
$PSBar->begin();
if (count($departemen) > 0) {
$PSBar->selection('Departemen', iSelect('ff_departemen', $departemen, $depat, $PSBar->selws, $fmod . "_get(1)"));
} else {
$PSBar->end();
hiddenval('ff_departemen', $dept);
hiddenval('ff_angkatan', $angk);
departemen_warn(0);
$PSBar->pass = false;
}
if (count($angkatan) > 0) {
$PSBar->selection('Angkatan', iSelect('ff_angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get(1)"));
<?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();
}
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
require_once MODDIR . 'apps/aka.php';
$fmod = 'peminjaman_buku_get_cari';
$xtable = new xtable($fmod);
$keyw = gpost('pskeyword');
$lok = gpost('pslokasi');
$lokasi = lokasi_r($lok);
$PSBar = new PSBar_2(100);
$PSBar->begin();
if (count($lokasi) > 0) {
$PSBar->selection('Lokasi', iSelect('pslokasi', $lokasi, $lok, $PSBar->selws, "peminjaman_buku_get_cari(1)"));
} else {
$PSBar->end();
hiddenval('pslokasi', $lok);
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) {
<?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>.');
}
}
<?php
require_once(MODDIR.'control.php');
$opt=gpost('opt'); $cid=gpost('cid'); if($cid=='')$cid=0;
$keyw=gpost('keyword'); $keyn=gpost('keyon');
$fmod='katalog';
$xtable = new xtable($fmod,'Catalog');
$xtable->keyons=array('judul'=>'title','kode'=>'classification code','pengarang'=>'author','penerbit'=>'publisher');
hiddenval('opf','kat');
if($opt=='af'||$opt=='uf') require_once(VWDIR.'en/katalog_form.php');
else{
// Query
$f=dbTF('pus_katalog:replid,judul,klasifikasi,pengarang,penerbit','pus_klasifikasi:kode as n1,kode','pus_pengarang:nama as n2','pus_penerbit:nama as n3');
$j=dbLJoin('pus_katalog','klasifikasi','pus_klasifikasi','replid');
$j.=dbLJoin('pus_katalog','pengarang','pus_pengarang','replid');
$j.=dbLJoin('pus_katalog','penerbit','pus_penerbit','replid');
$xtable->search_sql_set(array('judul'=>"pus_katalog.judul:LIKE",
'kode'=>"pus_klasifikasi.kode:=",
'pengarang'=>"pus_pengarang.nama:LIKE",
'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();
<?php
$fmod='statistik';
$xtable = new xtable($fmod,'Buku','','','sirkulasi');
//$xtable->use_select();
$xtable->noopt=true;
$xtable->pageorder="cnt DESC,mtipe";
$lok=gpost('lokasi');
$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);
<?php
appmod_use('keu/rekening');
$bukutahun = tahunbuku_getaktif();
$tahunbuku = tahunbuku_getaktifid();
$saldo_awal = tahunbuku_getsaldoawal();
echo '<div id="tabelrekx" style="display:">';
$xtable = new xtable($fmod);
$xtable->noopt = true;
$xtable->tbl_width = '1000px';
$xtable->tbl_style = 'float:left;margin-bottom:30px';
$xtable->row_strip = false;
$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)) {
