} 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(); $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){
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}'); $n = 0; while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nis'], 100); $xtable->td($r['nama']); if (admin_isoperator()) {
$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)); if($ncek_y<$ncek){ echo '<div class="infobox">Item yang sudah di cek : <b>'.$ncek_y.'</b> dari <b>'.$ncek.'</b> item.</div>'; } else { echo '<div class="infobox">Semua item sebanyak <b>'.$ncek.'</b> item sudah dicek.</div>'; } $xtable->search_box('cari barkode'); if($xtable->ndata>0){ // Table head $xtable->head('@barkode','@judul','@Cek~C','@Waktu cek'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $t1=mysql_query("SELECT pus_buku.barkode,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='".$r['buku']."'"); //echo $r1=mysql_fetch_array($t1); $xtable->td($r['barkode'],120); $xtable->td(buku_judul($r['judul'])); $s='<span style="color:'.($r['cek']=='Y'?'':'#ff0000').'"><b>'.$r['cek'].'</b></span>'; $xtable->td($s,40,'c'); $d=explode(" ",$r['ts']); if($r['cek']=='Y') $xtable->td(fftgl($d[0])." - ".$d[1],160);
$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()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('pus_buku.barkode','pus_katalog.judul')); if($xtable->ndata>0){ echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">'; $xtable->head('@Barkode','@Judul','{44px}');
// Query $db = new xdb("keu_transaksi"); $db->where_and("keu_transaksi.tahunbuku='{$tahunbuku}'"); $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 {
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')); $xtable->search_box('nomor ID atau nama member'); if($xtable->ndata>0){ echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">'; $xtable->head('@!ID Member','@Nama','{44px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['nid'],80); $xtable->td($r['nama']); if(admin_isoperator()) $s='<button class="btn" onclick="sirkulasi_peminjaman_form_member_set(3,'.$r['replid'].')">Pilih</button>~40px'; else $s='<div style="height:23px;width:40px"></div>'; $xtable->opt($r['replid'],$s); $xtable->row_end();}$xtable->foot(); echo '</div>';
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->btnbar_begin(); echo '<button style="float:left;margin-right:6px" class="btnz" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_c . '\');presensiguru_form(\'af\',0)">Presensi hari ini</button>'; echo '<div class="sfont" style="float:left;margin-top:4px">atau klik pada tanggal utuk mengedit presensi guru.</div>'; $xtable->search_box('nama guru'); $xtable->btnbar_end(); $absensi = array('0' => '', 'h' => 'Hadir', 'a' => 'Abstain', 'i' => 'Ijin', 's' => 'sakit'); if ($xtable->ndata > 0) { // Table head $heads = array('@nama'); for ($i = 1; $i <= $dim; $i++) { $s = '!<div class="presensi_tgl_btn" title="Edit presensi guru tanggal ' . $i . '" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_cm . $i . '\');presensiguru_form(\'af\',0)">' . $i . '</div>'; array_push($heads, $s . '{C,24px}'); } array_push($heads, '%{C}'); array_push($heads, '{30px,C}'); $xtable->head($heads); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); //$xtable->td($r['nis'],60);
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('hrd_pegawai'); $db->field("hrd_pegawai:replid,nip,nama"); $db->where_and($xtable->search_sql_get()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('hrd_pegawai.nip','hrd_pegawai.nama')); $xtable->search_box('nip atau nama member'); if($xtable->ndata>0){ echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">'; $xtable->head('@!ID Member','@Nama','{44px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['nip'],80); $xtable->td($r['nama']); if(admin_isoperator()) $s='<button class="btn" onclick="sirkulasi_peminjaman_form_member_set(2,'.$r['replid'].')">Pilih</button>~40px'; else $s='<div style="height:23px;width:40px"></div>'; $xtable->opt($r['replid'],$s); $xtable->row_end();}$xtable->foot(0); echo '</div>';
*/ // Query $db=new xdb('hrd_pegawai'); $db->field('hrd_pegawai:replid,nip,nama',"COUNT(pus_peminjaman.buku) as cnt","SUM(CASE pus_peminjaman.status WHEN '1' THEN 1 ELSE 0 END) as cntpjm"); $db->join_cust("pus_peminjaman ON (pus_peminjaman.member = hrd_pegawai.replid AND pus_peminjaman.mtipe = '2')"); $db->where_and($xtable->search_sql_get()); $db->group("hrd_pegawai.replid"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('hrd_pegawai.nip','hrd_pegawai.nama','','','cntpjm','cnt')); $xtable->btnbar_begin(); //$xtable->btnbar_add(); $xtable->search_box('nip atau nama pegawai'); $xtable->btnbar_end(); if($xtable->ndata>0){ // Table head $xtable->head('@!NIP','@Nama','Jml item sedang dipinjam{200px}','@Total peminjaman{120px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['nip'],80); $xtable->td($r['nama']); $xtable->td($r['cntpjm'],200); $xtable->td($r['cnt'],120); $xtable->opt_ud($r['replid']); $xtable->row_end();}$xtable->foot(); }else{$xtable->nodata();}
/* // Page Selection Bar $PSBar = new PSBar_2(100); $PSBar->begin(); $PSBar->selection('Tampilkan',iSelect('tampilx',array(0=>'item belum dicek',1=>'item sudah dicek',2=>'semua item'),$tamp,$PSBar->selws,$fmod."_get()")); $PSBar->end(); */ echo '<div style="width:100%;float:left;height:20px"></div>'; $xtable->btnbar_begin(); echo '<div class="sfont" style="float:left;width:80px;margin-top:4px;margin-right:4px"><b>Tampilkan:</b></div>'; echo iSelect('tampil',array(0=>'item belum dicek',1=>'item sudah dicek',2=>'semua item'),$tamp,'float:left;margin-right:4px',$fmod."_get()"); //echo '<button class="btnz" style="float:left;margin-right:4px" onclick="stocktake_note()">Selesai</button>'; echo '<button title="Muat ulang." class="btn" style="float:left;margin-right:4px" onclick="stocktake_note()"><div class="bi_relb"> </div></button>'; //$xtable->btnbar_add(); $xtable->search_box('','barkode atau judul buku'); //$xtable->btnbar_print(); $xtable->btnbar_end(); $xtable->search_info(); if($xtable->ndata>0){ // Table head $n=0; $xtable->head('@Barkode','@Judul','@Cek~C','Keterangan'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $xtable->td($r['barkode'],120); $xtable->td(buku_judul($r['judul']),300); $xtable->td($r['cek'],50,'c'); //td($a,$b='*',$c='',$k='',$atr=''){
$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.ct"; // Query $db = new xdb("keu_transaksi"); $db->where_and("keu_transaksi.jenis='" . JT_INBRG . "'"); $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')); $xtable->btnbar_begin(); echo '<button title="Penerimaan barang" class="btn" onclick="' . $fmod . '_form(\'af\')"><div class="bi_boxin">Penerimaan barang</div></button>'; $xtable->search_box('nomor transaksi atau uraian'); $xtable->btnbar_end(); $xtable->search_info('data transaksi dengan uraian atau nomor "<b>{keyw}</b>".'); if ($xtable->ndata > 0) { // Table head $xtable->head('!Tanggal/<br/>No. Transaksi{110px}', 'Uraian', 'Detil Jurnal', '{50px}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); if ($r['jenis'] == JT_INCOME) { $cl = '#00c804'; } else { if ($r['jenis'] == JT_SISWA) { $cl = '#00c804'; } else { if ($r['jenis'] == JT_CALONSISWA) { $cl = '#00c804';
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 = siswa_db_bykelas($kls, $ting); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql('nama')); $xtable->btnbar_begin(); echo '<button style="float:left;margin-right:6px" class="btnz" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_c . '\');presensi_form(\'af\',0)">Presensi hari ini</button>'; echo '<div class="sfont" style="float:left;margin-top:4px">atau klik pada tanggal utuk mengedit presensi siswa.</div>'; $xtable->search_box('nama siswa'); $xtable->btnbar_end(); $absensi = array('0' => '', 'h' => 'Hadir', 'a' => 'Abstain', 'i' => 'Ijin', 's' => 'sakit'); if ($xtable->ndata > 0) { // Table head $heads = array('@nama'); for ($i = 1; $i <= $dim; $i++) { $s = '!<div class="presensi_tgl_btn" title="Edit presensi tanggal ' . $i . '" onclick="inputdateSetDate(\'tanggal\',\'' . $tgl_cm . $i . '\');presensi_form(\'af\',0)">' . $i . '</div>'; array_push($heads, $s . '{C,24px}'); } array_push($heads, '%{C}'); array_push($heads, '{30px,C}'); $xtable->head($heads); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); //$xtable->td($r['nis'],60);