<?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 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 require_once(MODDIR.'xtable/xtable.php'); require_once(MODDIR.'control.php'); $SOUF=stocktake_unfinished(); $fmod='katalog_buku_daftar'; $xtable=new xtable($fmod,'koleksi'); if($SOUF==0)$xtable->use_select(); $xtable->search_keyon('barkode=>pus_buku.barkode:EQ-1'); $xtable->pageorder="pus_buku.barkode"; if($SOUF!=0)$xtable->noopt=true; $kat=gpost('katalog',0); $lok=gpost('lokasi'); $lokasi=lokasi_r($lokasi,1); $db=new xdb("pus_buku"); $db->field("pus_buku.*","pus_lokasi:nama as nlokasi","pus_tingkatbuku:nama as ntingkat"); $db->join("lokasi","pus_lokasi"); $db->join("tingkatbuku","pus_tingkatbuku"); $db->where("pus_buku.katalog='$kat'"); $db->where_and($xtable->search_sql_get()); if($lok!=0) $db->where_and("pus_buku.lokasi='$lok'"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_buku.idbuku','pus_buku.callnumber','pus_buku.sumber','pus_buku.harga','pus_buku.tanggal','pus_buku.status','nlokasi','ntingkat')); // Page Selection Bar $PSBar = new PSBar_2(100); $PSBar->begin(); if(count($lokasi)>0){ $PSBar->selection('Lokasi',iSelect('lokasi',$lokasi,$lok,$PSBar->selws,$fmod."_get()")); } else {
<?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 $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");
<?php $opt = gpost('opt'); $cid = gpost('cid', 0); $fmod = 'pegawai'; if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'pegawai_form.php'; } else { $xtable = new xtable($fmod, 'pegawai'); $xtable->search_keyon('nama=>hrd_pegawai.nama:LIKE-0', 'nip=>hrd_pegawai.nip:EQ-1'); $xtable->pageorder = "hrd_pegawai.nama"; // Query $db = new xdb("hrd_pegawai"); $db->field("hrd_pegawai:*", "hrd_m_status:status as nstatus"); $db->join("status", "hrd_m_status"); $db->where($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('hrd_pegawai.nama', 'hrd_pegawai.nip', 'hrd_pegawai.status')); $xtable->btnbar_f('add', 'print', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama', '@!NIP', 'Status'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nama'], 200); $xtable->td($r['nip'], 100); $xtable->td($r['nstatus']); //$xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end();
hiddenval('katalog_view', $katalog_view); hiddenval('opf', 'kat'); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'katalog_form.php'; } else { /* SELECT katalog.*, COUNT(post_id) AS post_count FROM katalog LEFT JOIN blogger_posts ON katalog.blogger_id = blogger_posts.blogger_id WHERE katalog.AUX = 3 GROUP BY katalog.blogger_id ORDER BY post_count */ $xtable = new xtable($fmod, 'katalog'); $xtable->search_keyon('judul=>pus_katalog.judul-0', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-1', 'pengarang(nama pengarang)=>pus_pengarang.nama:LIKE-2', 'penerbit(nama penerbit)=>pus_penerbit.nama:LIKE-3'); $xtable->pageorder = "pus_katalog.judul"; $xtable->rpp = $katalog_view == 'list' ? $xtable->rpp : 21; // Query $db = new xdb("pus_katalog"); $db->field("pus_katalog:replid,judul,klasifikasi,pengarang,penerbit,kota,tahunterbit,halaman,isbn,deskripsi,callnumber", "pus_klasifikasi:kode as n1,kode", "pus_pengarang:nama as n2,nama2 as nkutip", "pus_penerbit:nama as n3", "COUNT(pus_buku.replid) as buku_count"); $db->join("replid", "pus_buku", "katalog"); $db->join("klasifikasi", "pus_klasifikasi"); $db->join("pengarang", "pus_pengarang"); $db->join("penerbit", "pus_penerbit"); $db->where($xtable->search_sql_get()); $db->group("pus_katalog.replid"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('judul', 'n1', 'n2', 'n3', 'callnumber', 'buku_count')); $SOUF = stocktake_unfinished();
$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")); $ncek_y=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='Y'")); $ncek=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl));
//$s.='<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'\')"><b> </b></button>'; $s .= '<button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'H\')"><b>H</b></button>'; $s .= ' <button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'S\')"><b>S</b></button>'; $s .= ' <button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'I\')"><b>I</b></button>'; $s .= ' <button class="presensi_btn" onclick="presensi_list_get_setabsen_sel(\'A\')"><b>A</b></button>'; $s .= '</div>'; $xtable->select_opt = '<div class="sfont" style="width:164px;float:left;margin-top:4px;margin-left:0px;margin-right:5px">set presensi siswa yang dipilih:</div>' . $s; $xtable->foot(); echo '</div>'; } else { $xtable->nodata(); } } else { // Per siswa $xtable = new xtable($fmod, 'siswa', '', 2); $xtable->search_keyon('kunci=>aka_siswa.nama:LIKE-0'); $xtable->search_box_pos('l'); $xtable->pageorder = "aka_siswa.nis"; $xtable->noopt = true; $xtable->use_select(); echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto">'; $xtable->head('Tgl{C}', 'Presensi{C}', 'Keterangan'); for ($i = 1; $i <= $dim; $i++) { $xtable->row_begin($i); //$ctgl=$tgl_cm.$i; $r = array('replid' => $i); $xtable->td($i, 40, 'c'); $t1 = mysql_query("SELECT absen,keterangan FROM aka_absen WHERE siswa='" . $cid . "' AND tanggal='" . $tgl_cm . $i . "'"); if (mysql_num_rows($t1) > 0) { $r1 = mysql_fetch_array($t1); $absen = $r1['absen'];
if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('kelas', $kls); kelas_warn(1); exit; } $PSBar->end(); $xtable = new xtable($fmod, 'siswa'); $xtable->use_select(); // epi_edit $xtable->select_noopt = true; // epi_edit // $xtable->select_cekfunc="siswa_pendataan_kelas_list_cek(param)"; $xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1'); $xtable->search_box_pos('l', '200px'); $db = siswa_db_bykelas($kls, $tingk); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $xtable->search_box('nis atau nama siswa'); $xtable->search_info('data siswa dengan nis atau nama "<b>{keyw}</b>"' . ($angk == 0 ? '' : ' pada tahun ajaran ' . $tahunajaran[$tajar]) . '.'); $fid = 0; if ($xtable->ndata > 0) { // $xtable->head('NIS','Nama','Tunggakan{R}','{40px}'); $xtable->head('NIS', 'Nama', 'Uang Sekolah{R}', '{40px}'); while ($r = mysql_fetch_array($t)) { // $xtable->row_begin(); $xtable->row_begin($r['replid']); $t2 = dbQSql("SELECT * FROM keu_pembayaran WHERE modul='{$modid}' AND siswa='" . $r['replid'] . "'");
$SOUF = stocktake_unfinished(); $fmod = 'daftarbuku'; $xtable = new xtable($fmod, 'Buku'); if ($SOUF == 0) { $xtable->use_select(); } $xtable->pageorder = "barkode,judul"; if ($SOUF != 0) { $xtable->noopt = true; } $lok = gpost('lokasi'); $lokasi = lokasi_r($lok, 1); $jen = gpost('jenisbuku'); $jenisbuku = jenisbuku_r($jen, 1); // Query $xtable->search_keyon('barkode=>pus_buku.barkode:EQ-0', 'judul=>pus_katalog.judul-1', 'callnumber=>pus_buku.callnumber-2', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-3', 'pengarang(nama pengarang)=>pus_pengarang.nama-4', 'penerbit(nama penerbit)=>pus_penerbit.nama-5'); $db = new xdb('pus_buku'); $db->field('pus_buku:replid,katalog,lokasi,barkode,idbuku,callnumber,status', 'pus_katalog:judul,klasifikasi,pengarang,penerbit', 'pus_klasifikasi:kode as n1,kode', 'pus_pengarang:nama as n2', 'pus_penerbit:nama as n3'); $db->join('katalog', 'pus_katalog'); $db->joinother('pus_katalog', 'klasifikasi', 'pus_klasifikasi'); $db->joinother('pus_katalog', 'pengarang', 'pus_pengarang'); $db->joinother('pus_katalog', 'penerbit', 'pus_penerbit'); $db->where($lok == 0 ? "" : "pus_buku.lokasi='{$lok}'"); $db->where_and($jen == 0 ? "" : "pus_katalog.jenisbuku='{$jen}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('barkode', 'judul', 'callnumber', 'n1', 'n2', 'n3', 'status')); // Page Selection Bar $PSBar = new PSBar_2(100); $PSBar->begin();
<?php appmod_use('aka/tahunlulus', 'aka/tingkat', 'aka/kelas', 'aka/siswa'); $opt = gpost('opt'); $cid = gpost('cid', 0); $fmod = 'alumni'; $xtable = new xtable($fmod); $xtable->search_keyon('nisn=>aka_siswa.nisn:EQ-0', 'nama=>aka_siswa.nama:LIKE-1'); $xtable->pageorder = "aka_siswa.nisn"; $dept = gpost('departemen'); $departemen = departemen_r($dept); if (count($departemen) > 0) { $tlulus = gpost('tahunlulus'); $tahunlulus = tahunlulus_r($tlulus, $dept); // Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); $s = '<button title="Tambah tahun kelulusan" class="btn" style="float:left" onclick="alumni_tahunlulus_form(\'af\')"><div class="bi_addb"> </div></button>'; $PSBar->selection('Tahun kelulusan', iSelect('tahunlulus', $tahunlulus, $tlulus, 'float:left;margin-right:4px;width:' . (intval($PSBar->selw) - 28) . 'px', $fmod . "_get()") . $s); if (count($tahunlulus) == 0) { $PSBar->pass = false; } $PSBar->end(); if ($PSBar->pass) { // Query $db = new xdb("aka_alumni"); $db->field("aka_alumni:replid,siswa as idsiswa,keterangan", "aka_siswa:nisn,nama", "departemen:nama as ndepartemen", "aka_angkatan:angkatan as nangkatan"); $db->join("siswa", "aka_siswa"); $db->joinother("aka_siswa", "angkatan", "aka_angkatan"); $db->joinother("aka_angkatan", "departemen", "departemen");
exit; } if (count($kelompok) > 0) { $PSBar->selection('Kelompok', iSelect('kelompok', $kelompok, $kel, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('kelompok', $kel); kelompok_warn(); exit; } $PSBar->end(); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'pendataan_form.php'; } else { $xtable->pageorder = "nopendaftaran,nama"; $xtable->search_keyon('nopendaftaran(nomor pendaftaran)=>EQ-0', 'nama-1'); // Query $db = new xdb("psb_calonsiswa"); $db->where("proses='{$pros}' AND kelompok='{$kel}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $xtable->opt_w = '50px'; $t = $db->query($xtable->pageorder_sql('nopendaftaran', 'nama')); $xtable->btnbar_begin(); ?> <div style="padding-top:4px;float:left;margin-right:10px"><b>Kuota:</b> <?php echo $nsiswa . ' dari ' . $kapasitas; ?> siswa</div> <div style="float:left;border:1px solid #01a8f7;height:4px;width:<?php
<?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();
$PSBar->selection_departemen($fmod, $dept); if (count($angkatan) > 0) { $PSBar->selection('Angkatan', iSelect('angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('angkatan', $angk); angkatan_warn(0, 'float:left'); $PSBar->pass = false; } $PSBar->end(); if ($PSBar->pass) { if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'siswa_form.php'; } else { $xtable = new xtable($fmod, 'siswa'); $xtable->search_keyon('nis=>aka_siswa.nis:EQ', 'nama=>aka_siswa.nama:LIKE'); $xtable->docname = "Data Siswa Angkatan " . angkatan_name($angk); $xtable->printparams = array('angkatan' => angkatan_name($angk)); // Query $db = new xdb("aka_siswa"); $db->field("aka_siswa:replid,nis,nisn,nama,tmplahir,tgllahir"); $db->where_and("aka_siswa.angkatan='{$angk}'"); $db->where_and($xtable->search_sql_get()); $t = $xtable->use_db($db, $xtable->pageorder_sql('nis', 'nisn', 'nama')); $xtable->btnbar_f('print', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir', '{50px}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nis'], 80);
<?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)"));
require_once(VWDIR.'katalog_form.php'); } else{ /* SELECT katalog.*, COUNT(post_id) AS post_count FROM katalog LEFT JOIN blogger_posts ON katalog.blogger_id = blogger_posts.blogger_id WHERE katalog.AUX = 3 GROUP BY katalog.blogger_id ORDER BY post_count */ $xtable = new xtable($fmod,'katalog'); $xtable->search_keyon('judul=>pus_katalog.judul-0', 'isbn(barcode)=>pus_buku.barkode-1', 'kode(kode klasifikasi)=>pus_klasifikasi.kode:EQ-2', 'pengarang(nama pengarang)=>pus_pengarang.nama:LIKE-3', 'penerbit(nama penerbit)=>pus_penerbit.nama:LIKE-4'); $xtable->pageorder="pus_katalog.judul"; $xtable->rpp=$katalog_view=='list'?$xtable->rpp:21; // Query $db=new xdb("pus_katalog"); $db->field("pus_katalog:replid,judul,klasifikasi,pengarang,penerbit,kota,tahunterbit,halaman,isbn,deskripsi,callnumber","pus_klasifikasi:kode as n1,kode","pus_pengarang:nama as n2,nama2 as nkutip","pus_penerbit:nama as n3","COUNT(pus_buku.replid) as buku_count"); $db->join("replid","pus_buku","katalog"); $db->join("klasifikasi","pus_klasifikasi"); $db->join("pengarang","pus_pengarang"); $db->join("penerbit","pus_penerbit"); $db->where($xtable->search_sql_get()); $db->group("pus_katalog.replid"); $t=$db->query();
$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'"); } if ($tampil == 'N') { $db->where_and("keu_pembayaran.lunas='0'");
<?php require_once(MODDIR.'control.php'); require_once(MODDIR.'xtable/xtable.php'); ?> <div style="float:left;width:100%;margin-bottom:20px;border-bottom:1px solid #01a8f7"> <div class="gptab" onclick="sirkulasi_peminjaman_form_member_list_siswa_get(0)">Siswa</div> <div class="gptab" onclick="sirkulasi_peminjaman_form_member_list_pegawai_get(0)">Pegawai</div> <div class="gptab1" onclick="sirkulasi_peminjaman_form_member_list_lain_get(0)">Member Luar</div> </div> <?php $fmod='sirkulasi_peminjaman_form_member_list_lain'; $xtable=new xtable($fmod,'item','',3); $xtable->search_box_pos('l'); $xtable->search_keyon('kunci=>pus_member.nid:EQ|pus_member.nama:LIKE-0,1'); /* SELECT aka_siswa.replid, aka_siswa.nis, aka_siswa.nama, COUNT( pus_peminjaman.buku ) AS cnt FROM aka_siswa LEFT JOIN pus_peminjaman ON ( pus_peminjaman.member = aka_siswa.replid AND pus_peminjaman.mtipe = '1' ) GROUP BY aka_siswa.replid */ // Query $db=new xdb('pus_member'); $db->where_and($xtable->search_sql_get()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('pus_member.nid','pus_member.nama'));
<?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('aka/tahunajaran', 'aka/tingkat', 'aka/kelas', 'aka/siswa'); $opt = gpost('opt'); $cid = gpost('cid', 0); $fmod = 'presensi'; $xtable = new xtable($fmod, 'presensi'); $xtable->noopt = true; $xtable->search_keyon('nama=>aka_siswa.nama:LIKE-1'); $dept = gpost('departemen'); $departemen = departemen_r($dept); if (count($departemen) > 0) { $tajar = gpost('tahunajaran'); $tahunajaran = tahunajaran_r($tajar, $dept); $ting = gpost('tingkat'); $tingkat = tingkat_r($ting, $tajar); $kls = gpost('kelas'); $kelas = kelas_r($kls, $ting, 1); $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