echo '</div>'; echo '</div>'; $gptab = gpost('gptab_index', '1'); echo '<div style="float:left;width:100%;margin-bottom:10px;border-bottom:1px solid #01a8f7">', '<div id="gptab1" class="gptab' . ($gptab == '1' ? '1' : '') . '" onclick="transaksi_tab_get(1)">Jurnal Umum</div>', '<div id="gptab2" class="gptab' . ($gptab == '2' ? '1' : '') . '" onclick="transaksi_tab_get(2)">Buku Besar</div>', '<div id="gptab3" class="gptab' . ($gptab == '3' ? '1' : '') . '" onclick="transaksi_tab_get(3)">Neraca Saldo</div>', '<div id="gptab4" class="gptab' . ($gptab == '4' ? '1' : '') . '" onclick="transaksi_tab_get(4)">Neraca Lajur</div>', '<div id="gptab5" class="gptab' . ($gptab == '5' ? '1' : '') . '" onclick="transaksi_tab_get(5)">Laporan Laba/Rugi</div>', '<div id="gptab6" class="gptab' . ($gptab == '6' ? '1' : '') . '" onclick="transaksi_tab_get(6)">Laporan Neraca</div>', '<div id="gptab7" class="gptab' . ($gptab == '7' ? '1' : '') . '" onclick="transaksi_tab_get(7)">Posisi Kas dan Bank</div>', '<div id="gptab8" class="gptab' . ($gptab == '8' ? '1' : '') . '" onclick="transaksi_tab_get(8)">Buku Tambahan</div>', '</div>'; hiddenval('gptab_index', $gptab); echo '<div id="transaksi_tab_1" style="float:left;width:100%;display:' . ($gptab == '1' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_jurnalumum.php'; echo '</div>'; echo '<div id="transaksi_tab_2" style="float:left;width:100%;display:' . ($gptab == '2' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_bukubesar.php'; echo '</div>'; echo '<div id="transaksi_tab_3" style="float:left;width:100%;display:' . ($gptab == '3' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_neracasaldo.php'; echo '</div>'; echo '<div id="transaksi_tab_4" style="float:left;width:100%;display:' . ($gptab == '4' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_neracalajur.php'; echo '</div>'; echo '<div id="transaksi_tab_5" style="float:left;width:100%;display:' . ($gptab == '5' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_labarugi.php'; echo '</div>'; echo '<div id="transaksi_tab_6" style="float:left;width:100%;display:' . ($gptab == '6' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_neraca.php'; echo '</div>'; echo '<div id="transaksi_tab_7" style="float:left;width:100%;display:' . ($gptab == '7' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_kasbank.php'; echo '</div>'; echo '<div id="transaksi_tab_8" style="float:left;width:100%;display:' . ($gptab == '8' ? '' : 'none') . '">'; require_once VWDIR . 'transaksi_bukutambahan.php'; echo '</div>'; hiddenval('transaksi_tab_num', 8);
$lok = $r['lokasi']; $sat = $r['satuan']; $tingb = $r['tingkatbuku']; $lokasi = lokasi_r($lok); $satuan = satuan_r($sat); $tingkatbuku = tingkatbuku_r($tingb); } $fform->ptop = 20; $fform->head(); if ($opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form hiddenval('katalog', $r['katalog']); $fform->fg('Data buku'); $fform->fl('Judul', '<b>' . buku_judul($rk['judul']) . '</b>'); hiddenval('nbuku', 0); $fform->fi('ID buku', iText('idbuku', $r['idbuku'], $fform->rwidths, '', '', 'disabled')); //hiddenval('idbuku',$r['idbuku']); $fform->fi('Barkode', iText('barkode', $r['barkode'], $fform->rwidths, '', '', 'disabled')); $fform->fi('Callnumber', iText('callnumber', $r['callnumber'], $fform->rwidths)); $fform->fi('Sumber', iRadio('sumber1', 'sumber', 0, 'Beli', $r['sumber'], '', 'onclick="katalog_buku_getkode(' . $cid . ')"')); $fform->fi('', iRadio('sumber2', 'sumber', 1, 'Pemberian', $r['sumber'], '', 'onclick="katalog_buku_getkode(' . $cid . ')"')); $fform->fi('Harga', iSelect('satuan', $satuan, $sat) . ' ' . iText('harga', $r['harga'], 'width:120px')); $fform->fi('Tanggal diperoleh', inputTanggal('tanggal', $r['tanggal'])); $fform->fg('Alokasi buku'); $fform->fi('Lokasi', iSelect('tlokasi', $lokasi, $lok, '', 'katalog_buku_getkode(' . $cid . ')')); $fform->fi('Tingkat', iSelect('ttingkatbuku', $tingkatbuku, $tingb, '', 'katalog_buku_getkode(' . $cid . ')')); } else { if ($opt == 'df') { // Delete form $fform->dlg_del($r['idbuku']);
$r = app_form_gpost('departemen', 'tahunajaran', 'pegawai', 'pelajaran', 'aktif', 'keterangan'); $r['pelajaran'] = gpost('spelajaran'); $r['aktif'] = '1'; } $fform->dimension(450); $fform->head(); if ($opt == 'af' || $opt == 'uf') { //$fform->fl('Departemen',departemen_name($r['departemen'])); //$fform->fl('Tahun ajaran',tahunajaran_name($r['tahunajaran'])); //$fform->fi('Status',iSelect('aktif',array('1'=>'Aktif','0'=>'Tidak aktif'),$r['aktif'])); //$fform->fa('Kode',iText('kode',$r['kode'],'width:40px')); require_once MODDIR . 'control.php'; // Add or Edit form $fform->fi('Mata Pelajaran', iSelect('pelajaran', pelajaran_opt(gpost('tahunajaran')), $r['pelajaran'])); $fform->fi('Pegawai', app_form_getpegawai('pegawai', $r)); $fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3)); hiddenval('aktif', 1); } else { if ($opt == 'df') { // Delete form if (0 > 0) { $fform->reg['dlg_del'] = 'Data <idata> masih digunakan. Apakah anda yakin untuk menghapus <idata> <data>?'; $fform->dlg_delw($r['nama'], 'Data-data kelas dan siswa yang termasuk dalam tingkat ini juga akan dihapus. Data yang sudah dihapus tidak dapat dikembalikan.'); } else { $fform->dlg_del($r['nama']); } //$fform->dlg_del($r['nilai']); } } $fform->foot(); }
while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nopendaftaran'], 120); $xtable->td($r['nama']); $xtable->td(fRp($r['nominal']), 110, 'r'); $xtable->td(fRp($r['jmlbayar']), 110, 'r'); if ($r['lunas'] == '1') { $s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>'; } else { $s = '<button class="btn" title="Klik untuk transaksi pembayaran." onclick="E(\'pembayaran\').value=' . $r['replid'] . ';pembayaran_form(\'af\')" style="width:100px">Belum bayar</button>'; } $xtable->td(fftgl($r['tglbayar']), 140); $xtable->td($s, 110, 'c'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata_cust('Tidak ditemukan data pembayaran.'); } // End of Tabel transaksi } else { hiddenval('tampil', 'all'); echo '<div style="float:left;width:100%;margin-bottom:6px"><div class="warnbox" style="margin-right:4px">Belum ada modul pembayaran pendaftaran periode ini. Silahkan menambah modul pembayaran.</div></div><button onclick="modul_form(\'af\')" class="btnz" style="float:left" title="Tambah modul pembayaran."><div class="bi_add2">Modul pembayaran</div></button>'; } hiddenval('kategori', 3); hiddenval('reftipe', RT_PSB); hiddenval('refid', $pros); hiddenval('snama', 'Pendaftaran ' . $proses[$pros]); } else { departemen_warn(1); }
$PSBar->selection_departemen('penempatan', $dept); $PSBar->end(); if (count($departemen) > 0) { notifbox(); ?> <table cellspacing="0" cellpadding="0" width="100%"><tr valign="top"> <td width="45%" style="padding-right:10px"> <div id="loader3" class="loader" style="display:none"></div> <div id="data_calon" style="width:100%"> <?php require_once APPDIR . 'penempatan_calon_get.php'; ?> </div> </td> <td width="55%" style="border-left:1px solid #fff;padding-left:10px"> <div id="loader2" class="loader" style="display:none"></div> <div id="data_kelas" style="width:100%"> <?php require_once APPDIR . 'penempatan_kelas_get.php'; ?> </div> </td> </tr></table><?php } else { hiddenval('proses', $pros); hiddenval('kelompok', $kel); hiddenval('tahunajaran', $tajar); hiddenval('tingkat', $ting); hiddenval('kelas', $kls); departemen_warn(); }
<?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();
// 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"); $kapasitas = dbFetch("kapasitas", "psb_proses", "W/replid='{$pros}'"); $nsiswa = dbSRow("psb_calonsiswa", "W/proses='{$pros}' AND status<>0"); $barw = 300; ?> <div class="tbltopbar" style="width:100%"> <div style="float:right;margin-left:10px;border:1px solid #01a8f7;height:4px;width:<?php echo $barw; ?> px;margin-right:4px;margin-top:10px;margin-bottom:4px"> <?php
$w2.="pus_peminjaman.mtipe='2'"; $ct_sel2++;} 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");
$PSBar->pass=false; } if(count($tingkat)>0){ $PSBar->selection('Tingkat',iSelect('ff2_tingkat',$tingkat,$tingk,$PSBar->selws,$fmod."_get(1)")); } else { $PSBar->end(); hiddenval('ff2_tingkat',$tingk); hiddenval('ff2_kelas',$kls); tingkat_warn(0); $PSBar->pass=false; } if(count($kelas)>0){ $PSBar->selection('Kelas',iSelect('ff2_kelas',$kelas,$kls,$PSBar->selws,$fmod."_get(1)")); } else { $PSBar->end(); hiddenval('ff2_kelas',$kls); kelas_warn(0); $PSBar->pass=false; } $PSBar->end(); if($PSBar->pass){ $xtable->search_box('nis atau nama siswa'); $db=siswa_db_bykelas($kls,$tingk); $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){
} else { if ($jtrans == JT_OUTCOME) { $fform->idata = 'transaksi pengeluaran'; } else { $fform->idata = 'jurnal umum'; } } //jt_name($jtrans); $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form hiddenval('trans_pembayaran', $pid); hiddenval('trans_jenis', $jtrans); hiddenval('trans_nomer', $r['nomer']); hiddenval('trans_ct', $r['ct']); $fform->fl('<b>Nomor</b>', '<b><span id="box_trans_nomer">' . $no['nomer'] . '</span></b>'); $fform->fi('Tanggal', inputTanggal('trans_tanggal', $r['tanggal'], 'transaksi_getnomer()')); $fform->fi('Rek. Kas/Bank', iSelect('rekkas', $rekasbank, $r['rekkas'], $fform->rwidths, 'transaksi_getnomer()')); $fform->fg('pada'); $fform->fi('Rek. perkiraan', iSelect('rekitem', $rekening, $r['rekitem'], $fform->rwidths)); $fform->fa('Uraian', iTextArea('uraian', $r['uraian'], $fform->rwidths, 3)); $fform->fi('Nominal', iTextC('nominal', $r['nominal'], 'width:120px')); } else { if ($opt == 'df') { // Delete form $fform->rheight = ''; $fform->fc('Apakah anda yakin untuk menghapus data transaksi ini?'); $fform->fl('Nomor', '<b>' . $r['nomer'] . '</b>'); $fform->fl('Tanggal', fftgl($r['tanggal'])); $fform->fl('Uraian', $r['uraian']);
} else { $PSBar->end(); hiddenval('pstingkat', $ting); hiddenval('pskelas', $kls); hiddenval('keyword', ''); kelas_warn(1, 'float:left'); $PSBar->pass = false; } } if ($PSBar->pass) { if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('pskelas', $kelas, $kls, $PSBar->selws, $fmod . "_get(1)")); } else { $PSBar->end(); hiddenval('pskelas', $kls); hiddenval('keyword', ''); kelas_warn(1, 'float:left'); $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) {
$fform->ptop = 20; $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form $fform->fg('Data Koleksi'); $fform->fl('Judul', '<b>' . buku_judul($rk['judul']) . '</b>'); if ($opt == 'af') { $fform->fi('Jumlah koleksi baru', iText('nbuku', 1, 'width:30px;text-align:center', '', 'onblur="katalog_buku_cek()"') . ' item'); hiddenval('tbarkode', $r['barkode']); hiddenval('tidbuku', $r['idbuku']); } else { hiddenval('nbuku', 0); } //$fform->fi('ID buku',iText('idbuku',$r['idbuku'],$fform->rwidths,'','','disabled')); hiddenval('idbuku', $r['idbuku']); $fform->fi('Barkode', iText('barkode', $r['barkode'], $fform->rwidths, '', '', 'disabled')); $fform->fi('Callnumber', iText('callnumber', $r['callnumber'], $fform->rwidths)); $fform->fi('Sumber', iRadio('sumber1', 'sumber', 0, 'Beli', $r['sumber'])); $fform->fi('', iRadio('sumber2', 'sumber', 1, 'Pemberian', $r['sumber'])); $fform->fi('Harga', iSelect('satuan', $satuan, $sat) . ' ' . iText('harga', $r['harga'], 'width:120px')); $fform->fi('Tanggal diperoleh', inputTanggal('tanggal', $r['tanggal'])); $fform->fg('Alokasi Koleksi'); $fform->fi('Lokasi', iSelect('tlokasi', $lokasi, $lok, '', 'katalog_buku_getkode(\'' . $opt . '\')')); $fform->fi('Tingkat', iSelect('ttingkatbuku', $tingkatbuku, $tingb, '', 'katalog_buku_getkode(\'' . $opt . '\')')); //$fform->fi('Rak buku',iSelect('trakbuku',$rakbuku,$rak).' <img id="loader3" src="'.IMGR.'loadsmall.gif" style="display: none;">'); //$fform->fi('Kondisi',iSelect('kondisi',kondisi_a(),$r['kondisi'])); //$fform->fa('Keterangan',iTextarea('keterangan',$r['keterangan'],$fform->rwidths,3)); } else { if ($opt == 'df') { // Delete form
if (count($kelompok) > 0) { $PSBar->selection('Kelompok', iSelect('kelompok', $kelompok, $kel, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('kelompok', $kel); hiddenval('kriteria', $krit); kelompok_warn(0, 'float:left'); $PSBar->pass = false; } } if ($PSBar->pass) { if (count($kriteria) > 0) { $PSBar->selection('Kriteria', iSelect('kriteria', $kriteria, $krit, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('kriteria', $krit); kriteria_warn(0, 'float:left'); $PSBar->pass = false; } } $PSBar->end(); if ($PSBar->pass) { $t = mysql_query("SELECT psb_calonsiswa.*,aka_kelas.replid as idkelas, aka_kelas.kelas as nkelas,aka_tingkat.replid as idtingkat FROM psb_calonsiswa LEFT JOIN aka_kelas ON aka_kelas.replid=psb_calonsiswa.kelas LEFT JOIN aka_tingkat ON aka_tingkat.replid=aka_kelas.tingkat WHERE psb_calonsiswa.status='1' " . ($pros == 0 ? "" : " AND psb_calonsiswa.proses='{$pros}' ") . ($kel == 0 ? "" : " AND psb_calonsiswa.kelompok='{$kel}'") . ($krit == 0 ? "" : " AND psb_calonsiswa.kriteria='{$krit}' ") . " ORDER BY nama"); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { $xtable->optw = '40px'; $xtable->head('No Pendaftaran', 'Nama', 'Kelas~C'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nopendaftaran'], 100); $xtable->td($r['nama']);
<?php appmod_use('keu/budget'); $fmod = 'budget'; $xtable = new xtable($fmod, 'anggaran'); $tahunbuku = tahunbuku_getaktif(); $tbuku = $tahunbuku['replid']; if ($tbuku != 0) { // Page Selection Bar $PSBar = new PSBar_2(140); $PSBar->begin(); $PSBar->selection('Tahun buku', '<b>' . $tahunbuku['nama'] . '</b>'); hiddenval('tahunbuku', $tahunbuku['replid']); $PSBar->end(); $xtable->btnbar_f('add'); // Query $db = new xdb("keu_budget", "*", "tahunbuku='{$tbuku}'", "nama"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { // Table head $xtable->head('Nama Anggarang', 'Anggaran', 'Status anggaran', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nama'], 200); $xtable->td(fRp($r['nominal']), 110); $uses = budget_getuses($r['replid']); $sisa = $r['nominal'] - $uses; $clr = color_level($r['nominal'], $sisa < 0 ? $r['nominal'] : $uses); $bar = $sisa < 0 ? 480 : intval($uses * 480 / $r['nominal']); $s = '<div class="sfont" style="width:480px;height:20px;padding:1px;text-align:left"><span style="float:left">Total anggaran: <b>' . fRp($r['nominal']) . '</b></span></div>';
$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)")); } else { $PSBar->end(); 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}');
$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) { $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; } if ($PSBar->pass) { $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('Bulan', inputTanggal('tanggal', $tanggal, $fmod . '_get()', 'Ym') . ' ' . $s); } $PSBar->end(); if ($PSBar->pass) { // Query $db = guru_db_bytahunajaran($tajar); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('npegawai'));
$xtable->ndata = mysql_num_rows($t); $xtable->search_info($keyw, 'Hasil pencarian item dengan barkode atau judul "<b>' . $keyw . '</b>".', "E('pskeyword').value='';siswakelas_get_cari(1)"); if ($xtable->ndata > 0) { //$xtable->optw='50px'; $xtable->head('<input id="pscekt" type="checkbox" onclick="peminjaman_buku_get_cekall(this.checked)" />~C', 'Barkode', 'Callnumber', 'Judul'); $n = 0; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $s = '<input id="pscek' . $n . '" value="' . $r['replid'] . '" type="checkbox" onclick="peminjaman_buku_get_cek(' . $n . ',this.checked)" />'; $xtable->td($s, 20, 'c'); $xtable->td(srcrep($keyw, $r['barkode']), 100); //$xtable->td($r['idbuku'],120); $xtable->td($r['callnumber'], 80); $xtable->td(srcrep($keyw, buku_judul($r['judul']))); if (admin_isoperator()) { $s = '<button class="btn" onclick="peminjaman_buku_get_pilih_id(' . $n++ . ')">Pilih</button>~40px'; } else { $s = '<div style="height:23px;width:40px"></div>'; } $xtable->opt($r['replid'], $s); $xtable->row_end(); } $xtable->foot(); hiddenval('psceknum', $n); } else { $xtable->nodata_cust('Tidak data item dengan barkode atau judul <b>' . $keyw . '</b> di lokasi ini.'); } } else { $xtable->nodata_cust('<span style="color:' . CLGREY . '"><i>Masukkan barkode atau judul item.</i></span>'); } }
$data=farray(); $ttl='Tambah'; $data['tanggal1']=date("Y-m-d"); $data['tanggal2']=date("Y-m-d",strtotime("+7 day")); } $xform->title($ttl.' data peminjaman'); $xform->table_begin(); $xform->col_begin('50%'); $xform->set_fieldw(340); $xform->group_begin('Data Peminjam'); $s='<button title="Cari" class="btn" style="margin-right:4px" onclick="sirkulasi_member_add()"><div class="bi_srcb"> </div></button>'; $xform->fi('Peminjam',iText('smember','','width:250px;margin-right:4px','ID atau nama member','onkeyup="sirkulasi_member_cari(event)"').$s); hiddenval('member_id',0); hiddenval('member_tipe',0); hiddenval('sirkulasi_form',1); echo '<div id="datamember" class="xrowl" style="margin-top:10px">'; require_once(APPDIR.'sirkulasi_datamember.php'); echo '</div>'; $xform->col_begin('50%'); $xform->set_labelw(150); $xform->group_begin('Periode Peminjaman'); $xform->fi('Tanggal peminjaman',inputTanggal('tanggal1',$data['tanggal1'])); $xform->fi('Tanggal pengembalian',inputTanggal('tanggal2',$data['tanggal2'])); $xform->group_begin('Catatan Peminjaman',160); $xform->set_labelw(150); $xform->fi('Keterangan',iTextarea('keterangan','','width:250px',5)); $xform->table_end(0);
$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; } if ($PSBar->pass) { 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)) {
<?php require_once(MODDIR.'xform/xform.php'); require_once(MODDIR.'control.php'); $opt=gpost('opt'); $cid=gpost('cid'); if($cid=='')$cid=0; $fmod='katalog'; $xform=new xform($fmod,$opt,$cid); $klasifikasi=klasifikasi_opt(); $pengarang=pengarang_opt(); $penerbit=penerbit_opt(); $bahasa=bahasa_opt(); $jenisbuku=jenisbuku_opt(); $opf=gpost('opf'); hiddenval('opf',$opf); if($opt=='uf'){ // Nilai field editan $t=mysql_query("SELECT * FROM pus_katalog WHERE replid='$cid' LIMIT 0,1"); $data=mysql_fetch_array($t); $ttl='Edit'; } else { // Nilai field default $data=farray('replid','judul','klasifikasi-kode','klasifikasi','pengarang','penerbit','isbn','issn','penerjemah','tahunterbit','editor','photo','kota','volume','seri','bahasa','jenisbuku','deskripsi'); $data['halaman']=1; $ttl='Add New'; } $xform->title($ttl.' Catalog'); $xform->table_begin(); $xform->col_begin('50%'); // Kolom kiri lebar 50% $xform->set_fieldw(280); $xform->group_begin('Catalog Information'); // Grup field
$db = new xdb("aka_mutasi"); $db->field("aka_mutasi:replid,jenismutasi,siswa,tanggal,keterangan", "aka_siswa:nis as snis,nama as ssiswa"); $db->join("siswa", "aka_siswa"); $db->where("aka_mutasi.siswa='{$cid}'"); $r = $db->gofetch(); } else { $r = array(); $r['tanggal'] = date("Y-m-d"); } $fform->dimension(500); $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form $jenismutasi = jenismutasi_opt(); //$fform->fl('Departemen',departemen_name($r['departemen'])); $s = '<button id="mutasi_siswa_btn" title="Cari" class="btn" style="float:left" onclick="mutasi_siswa_formlist()"><div class="bi_srcb"> </div></button>'; $fform->fi('Siswa', iText('snis', $r['snis'], 'float:left;margin-right:4px;width:80px', '', 'readonly', 'onclick="mutasi_siswa_formlist()"') . iText('ssiswa', $r['ssiswa'], 'float:left;margin-right:4px;width:' . ($fform->rwidth - 110) . 'px', '', 'readonly', 'onclick="mutasi_siswa_formlist()"') . $s); hiddenval('siswa', $r['siswa']); $s = '<button title="Tambah jenis mutasi" class="btn" style="float:left" onclick="mutasi_jenismutasi_form(\'af\')"><div class="bi_addb"> </div></button>'; $fform->fi('Tanggal', inputTanggal('tanggal', $r['tanggal'])); $fform->fi('Jenis mutasi', iSelect('jenismutasi', $jenismutasi, $r['jenismutasi'], 'float:left;margin-right:4px;min-width:80px') . $s); $fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 4)); } else { if ($opt == 'df') { // Delete form $fform->dlg_del($r['ssiswa']); } } $fform->foot(); }
$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['sumnet']; $inp['cicilan']=$r['angsuran']; $q=dbInsert("keu_pembayaran",$inp); } } */ // Tabel transaksi echo '<table cellspacing="0" cellpadding="0" width="100%"><tr valign="top">'; echo '<td width="350px"><div id="box_siswa" style="margin-right:10px">'; require_once APPDIR . 'siswa_list_kelas_get.php'; echo '</td>'; echo '<td><div style="width:100%"><div id="box_pembayaran" style="display:none">'; require_once APPDIR . 'pembayaran_proses_get.php'; echo '</div></div></td>'; echo '</tr></table>'; // End of Tabel transaksi } else { echo '<div style="float:left;width:100%;margin-bottom:6px"><div class="warnbox" style="margin-right:4px">Belum ada modul pembayaran uang sekolah pada tahun ajaran ini. Silahkan menambah modul pembayaran.</div></div><button onclick="modul_form(\'af\')" class="btnz" style="float:left" title="Tambah modul pembayaran."><div class="bi_add2">Modul pembayaran</div></button>'; } hiddenval('kategori', 1); hiddenval('modul', $modid); hiddenval('reftipe', RT_SPP); hiddenval('refid', $tajar); hiddenval('siswa', 0); hiddenval('snama', 'Uang sekolah tahun ajaran ' . $tahunajaran[$tajar]); } else { departemen_warn(1); }
$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"); $db->field("pus_peminjaman:*", "pus_buku:barkode", "pus_katalog:judul", "DATEDIFF(pus_peminjaman.tanggal3,pus_peminjaman.tanggal2) as telat", "aka_siswa:nis,nama as nsiswa", "hrd_pegawai:nip,nama as npegawai"); $db->join("buku", "pus_buku"); $db->join("member", "aka_siswa"); $db->join("member", "hrd_pegawai");
$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"); $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());
if($opt=='af' || $opt=='uf'){ require_once(MODDIR.'control.php'); // Add or Edit form $fform->fg('Data Koleksi'); $fform->fl('Judul','<b>'.buku_judul($rk['judul']).'</b>'); if($opt=='af'){ $fform->fi('Jumlah koleksi baru',iText('nbuku',1,'width:30px;text-align:center','','onblur="katalog_buku_getkode('.$cid.')"').' item'); hiddenval('tbarkode',$r['barkode']); hiddenval('tidbuku',$r['idbuku']); } else { hiddenval('nbuku',0); } $fform->fi('ID buku',iText('idbuku',$r['idbuku'],$fform->rwidths,'','','disabled')); //hiddenval('idbuku',$r['idbuku']); $fform->fi('Barkode',iText('barkode',$r['barkode'],$fform->rwidths,'','','disabled')); //$fform->fi('Callnumber',iText('callnumber',$r['callnumber'],$fform->rwidths)); hiddenval('callnumber',$r['callnumber']); $fform->fi('Sumber',iRadio('sumber1','sumber',0,'Beli',$r['sumber'],'','onclick="katalog_buku_getkode('.$cid.')"')); $fform->fi('',iRadio('sumber2','sumber',1,'Pemberian',$r['sumber'],'','onclick="katalog_buku_getkode('.$cid.')"')); $fform->fi('Harga',iSelect('satuan',$satuan,$sat).' '.iText('harga',$r['harga'],'width:120px')); $fform->fi('Tanggal diperoleh',inputTanggal('tanggal',$r['tanggal'])); $fform->fg('Alokasi Koleksi'); $fform->fi('Lokasi',iSelect('tlokasi',$lokasi,$lok,'','katalog_buku_getkode('.$cid.')')); $fform->fi('Tingkat',iSelect('ttingkatbuku',$tingkatbuku,$tingb,'','katalog_buku_getkode('.$cid.')')); //$fform->fi('Rak buku',iSelect('trakbuku',$rakbuku,$rak).' <img id="loader3" src="'.IMGR.'loadsmall.gif" style="display: none;">'); //$fform->fi('Kondisi',iSelect('kondisi',kondisi_a(),$r['kondisi'])); //$fform->fa('Keterangan',iTextarea('keterangan',$r['keterangan'],$fform->rwidths,3)); } else if($opt=='df'){ // Delete form $fform->dlg_del($r['idbuku']);
if($opt=='u'){ $q=false; $inp=array(); $inp['bahasa']=gpost('bahasa'); log_print($inp['bahasa'].' admin id:'.$adminid); if(gpost('newpassword')!=''){ $inp['password']=gpost('newpassword'); } $q=dbUpdate("admin",$inp,"replid='$adminid'"); $fform->reg['notif_u']='Pengaturan telah disimpan. Silahkan login kembali.'; $fform->notif($q); } else { $t=mysql_query("SELECT * FROM admin WHERE replid='$adminid'"); $r=mysql_fetch_array($t); $fform->lwidth=150; $fform->fwidth=500; $fform->ptop=100; $fform->head(); require_once(MODDIR.'control.php'); // Add or Edit form //$fform->fg('Pengaturan Aplikasi'); //$fform->fi('Bahasa',iSelect('bahasa',array('id'=>'Indonesia','en'=>'Bahasa Inggris'),$r['bahasa'])); hiddenval('bahasa','id'); //'pwx' Password ganti (o,'r'+o,'x'+o) $fform->fg('Ubah Password','(<i>abaikan jika tidak ingin mengubah password</i>)'); $fform->fi('Password lama',iText('oldpassword','',$fform->rwidths)); $fform->fi('Password baru',iPswd('newpassword','',$fform->rwidths)); $fform->fi('Ulangi password baru',iPswd('rnewpassword','',$fform->rwidths)); $fform->foot(); } }?>
function hiddenval_gpost() { $a = func_get_args(); $n = count($a); for ($i = 0; $i < $n; $i++) { hiddenval($a[$i], gpost($a[$i])); } }
} } } $xtable->td(fhtgl($r['tanggal']), 80); $xtable->td('<b><span style="color:' . $cl . '">' . $r['nomer'] . '<br/><span style="color:#444">' . jt_jenisbukti($r['jenis']) . '</span>' . ($r['nobukti'] == '' ? '' : '<br/><span style="color:#444">' . $r['nobukti'] . '</span>') . '</span></b>', 120); $xtable->td(nl2br($r['uraian']), $ct_jurnaldetil == 1 ? 300 : '', '', 'id="xtd_urai' . $row . '"'); $xtable->td(fRp($r['nominal']), 100, 'r', 'id="xtd_nom' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? 'none' : '') . '"'); $t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid"); if (mysql_num_rows($t1) > 0) { $s = '<div style="background:#fff"><table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">'; while ($r1 = mysql_fetch_array($t1)) { $s .= '<tr><td>' . $r1['nrek'] . '</td><td width="40px" align="center">' . $r1['koderek'] . '</td><td width="100px" align="right">' . fRp($r1['debet']) . '</td><td width="100px" align="right">' . fRp($r1['kredit']) . '</td></tr>'; } $s .= '</table></div>'; } else { $s = ''; } $xtable->td($s, '', '', 'id="xtd_jd' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? '' : 'none') . '"'); $s = '<button class="btn" title="Cetak bukti transaksi" onclick="transaksi_print(\'' . $r['nomer'] . '\')"><div class="bi_prib"> </div></button>'; $xtable->opt($r['replid'], 'u', 'd'); $row++; } $xtable->foot(); hiddenval('xtd_jd_num', $row); echo '<form id="pageprinter" style="display:none" target="_blank" action="' . RLNK . 'print2.php?doc=jurnalumum&docname=Jurnal Umum&doprint=0" method="post"><input name="pagesql" type="hidden" value="' . $db->getsql() . '" /></form>'; } else { $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable->nodata_cust('Silahkan pilih laporan transaksi.'); }
$db->group("pus_peminjaman.mtipe,pus_peminjaman.member"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('nis,nip,nid','nsiswa,npegawai,nmember','mtipe','cnt')); // Page Selection Bar $PSBar = new PSBar_2(100,450); $PSBar->begin(); $PSBar->selection('Statistik',iSelect('statistik',$statistik,$stat,$PSBar->selws,$fmod."_get()")); if(count($lokasi)>0){ $PSBar->selection('Lokasi',iSelect('lokasi',$lokasi,$lok,$PSBar->selws,$fmod."_get()")); } else { $PSBar->end(); hiddenval('lokasi',$lok); lokasi_warn(0,'float:left'); $PSBar->pass=false; } $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 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();
if (count($tingkat) > 0) { $PSBar->selection('Tingkat', iSelect('pstingkat', $tingkat, $ting, $PSBar->selws, "pendataan_saudara_siswapilih(1)")); } else { $PSBar->end(); hiddenval('pstingkat', $ting); hiddenval('pskelas', $kls); tingkat_warn(1, 'float:left'); $PSBar->pass = false; } } if ($PSBar->pass) { if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('pskelas', $kelas, $kls, $PSBar->selws, "pendataan_saudara_siswapilih(1)")); } else { $PSBar->end(); hiddenval('pskelas', $kls); kelas_warn(1, 'float:left'); $PSBar->pass = false; } } $PSBar->end(); if ($PSBar->pass) { $t = mysql_query("SELECT * FROM aka_siswa WHERE kelas='{$kls}' ORDER BY nama"); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { //$xtable->optw='50px'; $xtable->head('NIS', 'NISN', 'Nama'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nis'], 120); $xtable->td($r['nisn'], 120);