<?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)) {