} 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) { //$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 {
$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(); $xtable->search_info(); $membertipe=array(1=>'Siswa',2=>'Pegawai',3=>'Member luar'); if($xtable->ndata>0){ $xtable->head('@!ID Member','@Nama member','@Jenis member','@Jumlah Item Dipinjam{R,150px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']); if($r['mtipe']==1){ $xtable->td($r['nis'],120); $xtable->td($r['nsiswa']); } else if($r['mtipe']==2){ $xtable->td($r['nip'],120); $xtable->td($r['npegawai']); } else { $xtable->td($r['nid'],120);
$db->where_and("keu_transaksi.tanggal>='{$tanggal1}'"); $db->where_and("keu_transaksi.tanggal<='{$tanggal2}'"); $db->where_and($w == "" ? "" : "(" . $w . ")"); $db->where_and($xtable->search_sql_get()); //$db->order("keu_transaksi.tanggal,keu_transaksi.nomer"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('keu_transaksi.tanggal', 'keu_transaksi.nomer', '', 'keu_transaksi.nominal')); //$t=$db->query($xtable->pageorder_sql('kode','nama')); $xtable->btnbar_begin(); //$xtable->btnbar_print(); //echo '<button class="btn" style="float:left;margin-right:4px" onclick="E(\'pageprinter\').submit()"><div class="bi_pri">Cetak</div></button>'; $xtable->search_box('Cari uraian atau nomor jurnal'); echo iCheckx('ct_jurnaldetil', 'Tampilkan detil jurnal', $ct_jurnaldetil, 'float:right;margin-left:4px;margin-right:30px;margin-top:4px', 'onclick="transaksi_jurnadetil(this.checked)"'); $xtable->btnbar_end(); $xtable->search_info('data transaksi dengan uraian atau nomor jurnal "<b>{keyw}</b>".'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!Tanggal', '@!No. Jurnal / <br/>Jenis Bukti / <br/>No. Bukti', 'Uraian', '@nominal{R' . ($ct_jurnaldetil == 1 ? ',h' : '') . '}', 'Detil Jurnal' . ($ct_jurnaldetil == 1 ? '' : '{h}')); $row = 0; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); if ($r['jenis'] == JT_INCOME) { $cl = '#00c804'; } else { if ($r['jenis'] == JT_OUTCOME) { $cl = '#ff1b1b'; } else { if ($r['jenis'] == JT_INBRG) { $cl = '#ff1b1b'; } else {
if(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; } $PSBar->end(); $xtable->btnbar_begin(); if($SOUF==0) $xtable->btnbar_add('','','Tambah koleksi baru'); $xtable->search_box('Cari barkode'); $xtable->btnbar_end(); $xtable->search_info('data buku dengan barkode "<b>{keyw}</b>"'.($lok==0?'':' pada lokasi '.preg_replace("/\[[^\[\]]+\]/","",$lokasi[$lok])).'.'); if($xtable->ndata>0){ // Table head $xtable->head('@Barkode','@!Nomor ID','@sumber','@harga~R','@Tanggal diperoleh','@Status','@lokasi','@tingkat'); while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']); $xtable->td($r['barkode']); $xtable->td($r['idbuku'],120); //$xtable->td($r['callnumber'],120); $xtable->td($r['sumber']==0?'Beli':'Pemberian',100); $xtable->td($r['satuan'].' '.$r['harga'],80,'r'); $xtable->td(fftgl($r['tanggal']),120); if($r['status']==1){ $s='Tersedia'; } else {
} $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'] . "'"); $r2 = dbFA($t2); $dibayar = 0; $t3 = dbQSql("SELECT * FROM keu_transaksi WHERE pembayaran='" . $r2['replid'] . "'"); while ($r3 = dbFA($t3)) { $dibayar += $r3['nominal']; // print_r($r3);exit(); }
$t=mysql_query("SELECT departemen FROM aka_angkatan WHERE replid='".$pemb['angkatan']."' LIMIT 0,1"); $r=mysql_fetch_array($t); $PSBar->selection('Departemen',departemen_name($r['departemen'])); $PSBar->selection('Angkatan',angkatan_name($pemb['angkatan'])); $PSBar->end(); */ $xtable = new xtable($fmod, 'siswa'); $xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1'); $xtable->search_box_pos('l', '200px'); $db = siswa_db_byangkatan($angk); $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 angkatan ' . $angkatan[$angk]) . '.'); $fid = 0; if ($xtable->ndata > 0) { $xtable->head('NIS', 'Nama', '{40px}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); if ($fid == 0) { $fid = $r['replid']; } $xtable->td($r['nis'], 100); $xtable->td($r['nama']); if (admin_isoperator()) { $s = '<button class="btn" title="Proses" onclick="E(\'siswa\').value=' . $r['replid'] . ';pembayaran_proses_get()"><div class="bi_arrow2b"> </div></button>~36px'; } else { $s = '<div style="height:23px;width:36px"></div>'; }
if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('pskelas', $kelas, $kls, $PSBar->selws, $fmod . '_get()')); } else { $PSBar->end(); hiddenval('pskelas', $kls); kelas_warn(1); $PSBar->pass = false; } } $PSBar->end(); $db = siswa_db_bykelas($kls, $ting, "tgllahir"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $xtable->search_box(); $xtable->search_info('data siswa dengan {keyon} "<b>{keyw}</b>"' . ($kls == 0 ? '' : 'pada kelas ' . $kelas[$kls]) . '.'); if ($xtable->ndata > 0) { $xtable->head('NIS', 'Nama'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nis'], 120); $xtable->td($r['nama']); if (admin_isoperator()) { $s = '<button class="btn" title="Lihat detil" onclick="pendataan_saudara_detil(\'' . $r['replid'] . '\')"><div class="bi_srcb"> </div></button> <button class="btn" onclick="pendataan_saudara_set(\'' . $r['nama'] . '\',\'' . $r['ndepartemen'] . '\',\'' . $r['tgllahir'] . '\')">Pilih</button>~72px'; } else { $s = '<div style="height:23px;width:40px"></div>'; } $xtable->opt($r['replid'], $s); $xtable->row_end(); } $xtable->foot();