<?php
$fmod='stocktake_hist';
$xtable=new xtable($fmod,'Riwayat Stock Opname');
$xtable->row_valign="top";
$xtable->pageorder="tanggal1";
$xtable->btnbar_begin();
echo '<button class="btn" onclick="stocktake_hist_back()"><div class="bi_arrow">Kembali</div></button>';
$xtable->btnbar_end();
// Query
$sql="SELECT * FROM pus_stockhist";
$t=mysql_query($sql);
$xtable->ndata=mysql_num_rows($t);
$t=mysql_query($sql.$xtable->pageorder_sql('nama','tanggal1','tanggal2'));
if($xtable->ndata>0){
// Table head
$xtable->head('@Nama Stock Opname','@Tanggal Mulai','@Tanggal selesai','Rangkuman','keterangan');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['nama'],200);
$xtable->td(fftgl($r['tanggal1']),120);
$xtable->td(fftgl($r['tanggal2']),120);
$tot=$r['nitem'];
$ncek=$r['nceky'];
$nnocek=$tot-$ncek;
$nwn=$r['nnote'];
$nnn=$nnocek-$nwn;
$s='<table class="stable" cellspacing="0" cellpadding="0" border="0" style="border:none !important">';
$s.='<tr><td style="border:none !important" width="180px">Total item di database</td><td style="border:none !important">: '.$tot.' item</td></tr>';
<?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();
}
$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");
$db->joinother("pus_buku", "katalog", "pus_katalog");
$db->where("pus_peminjaman.status = '0'");
$db->where_and("pus_peminjaman.tanggal3 >= '{$tanggal1}'");
$db->where_and("pus_peminjaman.tanggal3 <= '{$tanggal2}'");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('barkode', 'judul', 'nsiswa,npegawai', 'tanggal1', 'tanggal2', 'tanggal3', 'telat'));
$xtable->btnbar_begin();
if ($SOUF == 0) {
$xtable->btnbar_add();
} else {
echo '<div class="warnbox">Pengembalian tidak dapat dilakukan selama proses stock opname berlangsung.</div>';
}
$xtable->search_box();
//$xtable->btnbar_print();
$xtable->btnbar_end();
$xtable->search_info();
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Barkode Item', '@Judul Item', '@Peminjam', '@Tgl peminjaman', '@Tgl pengembalian', '@Tgl dikembalikan', '@Terlambat{R}', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
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();
//$xtable->btnbar_print();
$xtable->btnbar_end();
$xtable->search_info();
if($xtable->ndata>0){
// Table head
$xtable->head('@Title','@Classification','@Author','@Publisher');
while($r=mysql_fetch_array($t)){$xtable->row_begin();
$xtable->td($r['judul'],0,'','judul');
$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));
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');
}
$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}');
$n=0;
while($r=mysql_fetch_array($t)){$xtable->row_begin($r['replid']);
$xtable->td($r['barkode'],100);
$xtable->td(buku_judul($r['judul']));
if(admin_isoperator()) $s='<button class="btn" onclick="xtable3_cekall(false);xtable3_sel('.$n.');sirkulasi_peminjaman_form_buku_form(\'a\',\'0\',true)">Pilih</button>~40px';
else $s='<div style="height:23px;width:40px"></div>';
$xtable->opt($r['replid'],$s);
$n++;
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();
}
$xtable->foot();
echo '</div>';
} else {
$kat = $cid;
hiddenval('lokasi', $lok);
hiddenval('grup', $grup);
hiddenval('katalog', $kat);
if ($opt == 'af' || $opt == 'uf') {
require_once VWDIR . 'katalog_form.php';
} else {
// Katalog Query
$tk = mysql_query("SELECT * FROM sar_katalog WHERE replid='{$cid}'");
$rk = mysql_fetch_array($tk);
// Query
$sql = "SELECT * FROM sar_barang WHERE katalog='{$cid}'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
// Page sort and order
$po = $xtable->pageorder_sql('kode', 'barkode', 'kondisi');
$t = mysql_query($sql . $po);
$xtable->btnbar_f('b-Grup barang', '<button class="btn" onclick="katalog_form(\'uf\',\'' . $rk['replid'] . '\')"><div class="bi_edit">Edit informasi barang</div></button>', 'add');
notifbox();
hiddenval('opf', 'uni');
hiddenval('kondisi_1', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='1'")));
hiddenval('kondisi_2', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='2'")));
hiddenval('kondisi_3', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='3'")));
hiddenval('kondisi_4', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='4'")));
?>
<div class="tbltopmbar" style="float:left;margin-top:10px;margin-bottom:10px">
<table class="stable" cellspacing="0" cellpadding="0" width="100%"><tr valign="top">
<td width="400px">
<table class="stable" cellspacing="0" cellpadding="0">
<tr height="24px"><td colspan="2"><b>Informasi Barang :</b></td></tr>
<tr height="24px"><td width="140px">Nama barang:</td><td><?php
<?php
$fmod = 'posisi';
$xtable = new xtable($fmod, 'posisi pegawai');
// Query
$db = new xdb("hrd_m_posisi");
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql('posisi'));
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Nama posisi', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['posisi'], 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
<?php
$fmod = 'status';
$xtable = new xtable($fmod, 'status pegawai');
// Query
$db = new xdb("hrd_m_status");
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql('status'));
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Nama status', 'Reminder', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['status'], 200);
$xtable->td($r['reminder'] . ' hari', 200);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
$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();
// Query
$db = new xdb("sar_grup", "", "lokasi='{$lok}'");
$t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama'));
$xtable->btnbar_begin();
$xtable->btnbar_add();
echo '<div class="sfont" style="float:right;margin-top:4px">Total aset: ' . fRp(lokasi_aset($lok)) . '</div>';
$xtable->btnbar_end();
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@kode', '@nama Grup barang', 'Jumlah unit~C', 'Unit tersedia~C', 'Unit dipinjam~C', 'Total aset~R', 'Keterangan');
$nom = 1;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE grup='" . $r['replid'] . "'"));
$xtable->td($r['kode'], 100);
$xtable->td($r['nama'], 200);
$xtable->td($n, 100, 'c');
$xtable->td(0, 100, 'c');
}
$db = new xdb("aka_daftarnilai", "*", "penilaian='{$peni}'");
$nlulus = 0;
$t = $db->go();
while ($r = dbFA($t)) {
if ($r['nilai'] >= $dpeni['kkm']) {
$nlulus++;
}
}
$db = siswa_db_bykelas($kls);
$db->field("aka_daftarnilai:nilai,keterangan as ketnilai", "IF(aka_daftarnilai.nilai < " . $dpeni['kkm'] . ", 1, 0) as tuntas");
$db->join("siswa", "aka_daftarnilai", "siswa");
$db->where_and("aka_daftarnilai.penilaian='{$peni}'");
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql("aka_siswa:nis,nama", "aka_daftarnilai.nilai", "tuntas"));
echo '<div style="width:100%;float:left">';
$xtable->btnbar_begin();
echo '<button class="btn" style="float:left;margin-right:4px" onclick="daftarnilai_form(\'uf\',0)"><div class="bi_edit">Edit nilai</div></button>';
//echo '<button class="btn" style="float:left;margin-right:4px"><div class="bi_pri">Cetak</div></button>';
$nlulus = $xtable->ndata == 0 ? 0 : $nlulus * 100 / $xtable->ndata;
echo '<div class="sfont" style="float:right;margin-top:4px;margin-left:40px">Persentase ketuntasan siswa: <b>' . $nlulus . ' %</b></div>';
echo '<div class="sfont" style="float:right;margin-top:4px;margin-left:10px">SKM: <b>' . $dpeni['kkm'] . '</b></div>';
$xtable->btnbar_end();
echo '</div>';
//echo $xtable->ndata;
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@!NIS', '@Nama', '@Nilai{C}', '@Ketuntasan', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
}
$PSBar->end();
if ($PSBar->pass) {
$db = new xdb("aka_penilaian");
$db->field("SUM(aka_penilaian.bobot) as tbobot");
$db->where_ands("aka_penilaian:guru='{$gid}',pelajaran='{$pel}',kelas='{$kls}'");
$t1 = $db->query();
$r1 = mysql_fetch_array($t1);
$tbobot = $r1['tbobot'];
// Query
$db = new xdb("aka_penilaian");
$db->field("aka_penilaian:*");
$db->where_ands("aka_penilaian:guru='{$gid}',pelajaran='{$pel}',kelas='{$kls}'");
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql("aka_penilaian:nama,kode,kkm,bobot"));
$xtable->btnbar_f('add');
//echo $xtable->ndata;
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Penilaian', '@Kode{C}', '@bobot penilaian{C}', '!Persentase Bobot{C}', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin($r['replid']);
$xtable->td($r['nama'], 300);
$xtable->td($r['kode'], 100, 'c');
//$xtable->td($r['kkm'],100,'c');
$xtable->td($r['bobot'], 120, 'c');
$xtable->td(number_format($r['bobot'] * 100 / $tbobot, 2) . ' %', 120, 'c');
$xtable->td(nl2br($r['keterangan']));
$s = '<button class="btn" title="Daftar nilai siswa." onclick="openPage(' . app_page_getindex('daftarnilai') . ',\'daftarnilai\',false,\'pelajaran=' . $pel . '&kelas=' . $kls . '&penilaian=' . $r['replid'] . '\')"><div class="bi_lis" style="">Nilai</div></button> ~60';
$xtable->opt($r['replid'], $s, 'u', 'd');
<?php
require_once MODDIR . 'control.php';
$fmod = 'inventaris';
$xtable = new xtable($fmod, 'Grup barang');
$lok = gpost('lokasi');
$lokasi = lokasi_r($lok);
if (count($lokasi) > 0) {
// Query
$sql = "SELECT * FROM sar_grup WHERE lokasi='{$lok}'";
$t = mysql_query($sql);
$xtable->ndata = mysql_num_rows($t);
// Page sort and order
$po = $xtable->pageorder_sql('kode', 'nama');
$t = mysql_query($sql . $po);
$xtable->btnbar_sth();
?>
<td width="80px" align="left"><b>Lokasi:</b></td>
<td width="120px"><?php
echo iSelect('lokasi', $lokasi, $lok, '', $fmod . "_get()");
?>
</td>
<td align="right">
<?php
$xtable->btnbar_add();
?>
</td>
<?php
$xtable->btnbar_stf();
notifbox();
?>
$db->where_and($w3);
if($xtable->keyn=='memberid' && $xtable->page_search==1){
$db->where_and("!((CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nis WHEN '2' THEN hrd_pegawai.nip ELSE pus_member.nid END) = '".$xtable->keyw."')");
} else if($xtable->keyn=='nama' && $xtable->page_search==1){
if($xtable->keyw=='') $keywo=" = '' ";
else $keywo=" LIKE '%".$xtable->keyw."%' ";
$db->where_and("!((CASE pus_peminjaman.mtipe WHEN '1' THEN aka_siswa.nama WHEN '2' THEN hrd_pegawai.nama ELSE pus_member.nama END) ".$keywo.")");
} else {
$db->where_and($xtable->search_sql_get());
}
if(!($ct_sel1==0 || $ct_sel2==0 || $ct_sel3==0)){
$t=$db->query();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('pus_peminjaman.tanggal1','nsiswa,npegawai,nmember','pus_buku.barkode','pus_katalog.judul','pus_peminjaman.tanggal2','pus_peminjaman.status','pus_peminjaman.tanggal3'));
}
echo '<table cellspacing="0" cellpadding="0" style="margin-bottom:20px"><tr valign="top"><td width="250px">';
echo '<div class="sfont" style="float:left;width:100%;margin-top:0px;margin-bottom:10px"><b>Tampilkan catatan sirkulasi:</b></div>';
echo '<div style="float:left;width:100%">';
echo '<div style="float:left">';
echo '<table cellspacing="0" cellpadding="0">';
echo '<tr height="24px">',
'<td>'.iCheckx('ct_pinjam','masih dipinjam',$ct_pinjam).'</td>',
'</tr>';
echo '<tr height="24px">',
'<td>'.iCheckx('ct_kembali','sudah dikembalikan',$ct_kembali).'</td>',
'</tr>';
echo '</table>';
echo '</div>';
$nkelompok = '';
}
$xform->table_begin('<div id="box_kelompokbrg_nama" style="float:left;margin-top:2px;margin-left:6px;height:24px">' . $nkelompok . '</div>');
$xform->col_begin();
if ($kelompokbrg != 0) {
$fmod = 'inventory_brg';
$xtable = new xtable($fmod, 'barang', '', '', 'inventory');
$xtable->pageorder = "kode";
// Query
$db = new xdb("keu_brg");
if ($kat !== 0) {
$db->where("kelompokbrg='{$kelompokbrg}'");
}
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('kode', 'nama'));
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@Kode', '@Nama Barang', '@Tanggal diperoleh', '@jumlah barang{100px}', 'Keterangan');
$lkat = 0;
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kode'], 100);
$xtable->td($r['nama'], 250);
$xtable->td(fftgl($r['tanggal']), 120);
$xtable->td($r['unit'] . ' ' . $r['satuan'], 100);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
}
$xtable->foot();
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->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}');
$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();
if (count($lokasi) > 0) {
$PSBar->selection('Lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('lokasi', $lok);
hiddenval('jenisbuku', $jenb);
lokasi_warn();
$PSBar->pass = false;
}
if ($PSBar->pass) {
if (count($jenisbuku) > 0) {
$PSBar->selection('Jenis koleksi', iSelect('jenisbuku', $jenisbuku, $jen, $PSBar->selws, $fmod . "_get()"));
}
$w .= "keu_transaksi.jenis='" . JT_INBRG . "'";
$sel++;
}
if ($sel > 0) {
// 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) {
}
$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);
$xtable->td($r['nisn'], 120);
$xtable->td($r['nama']);
$xtable->td($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 100);
//$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>';
$xtable->opt($r['replid'], 'v');
$xtable->row_end();
}
$xtable->foot();
$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()) {
$s = '<button class="btn" onclick="xtable2_cekall(false);xtable2_sel(' . $n . ');siswa_pendataan_kelas_siswa_form(\'a\',\'0\',true)"">Pilih</button>~40px';
} else {
$s = '<div style="height:23px;width:40px"></div>';
}
$xtable->opt($r['replid'], $s);
$n++;
'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();
$xtable->ndata=mysql_num_rows($t);
$t=$db->query($xtable->pageorder_sql('judul','n1','n2','n3','callnumber','buku_count'));
$SOUF=stocktake_unfinished();
$xtable->btnbar_begin();
if($SOUF==0) $xtable->btnbar_add();
else echo '<div class="warnbox">Perubahan katalog tidak dapat dilakukan selama proses stock opname berlangsung.</div>';
if($katalog_view=='detil'){
echo '<button title="Tampilan daftar" class="btn" style="float:left;margin-right:4px" onclick="E(\'katalog_view\').value=\'list\';katalog_get()"><div class="bi_lis">Daftar</div></button>';
} else {
echo '<button title="Tampilan detil" class="btn" style="float:left;margin-right:4px" onclick="E(\'katalog_view\').value=\'detil\';katalog_get()"><div class="bi_thumb">Detil</div></button>';
}
$xtable->btnbar_print();
<?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();
}
/*
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);
<?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");
$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 {
$PSBar->end();
hiddenval('lokasi',$lok);
lokasi_warn(0,'float:left');
$PSBar->pass=false;
}
$PSBar->end();
$xtable->btnbar_begin();
$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'");
}
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql("psb_calonsiswa.nopendaftaran", "psb_calonsiswa.nama", "", "", "keu_transaksi.tanggal", "keu_pembayaran.lunas"));
$t = $s = '';
//$s.='<button title="Tampilkan." class="btn" style="float:right;margin-left:4px" onclick="stocktake_note()"><div class="bi_relb"> </div></button>';
$s .= iSelect('tampil', array('all' => 'Semua', 'Y' => 'Sudah bayar', 'N' => 'Belum bayar'), $tampil, 'float:right;margin-left:4px;margin-right:20px', $fmod . '_get()');
$s .= '<div class="sfont" style="float:right;margin-top:4px;margin-left:4px">
<b>Tampilkan:</b>
</div>';
$t .= '<div class="sfont" style="float:left;width:100%;margin-bottom:15px"><b>tanggal:</b>';
$t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(1)" >[hari ini]</a>';
$t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(2)" >[bulan ini]</a>';
$t .= '</div>';
$t .= '<div style="float:left;width:100%;margin-bottom:40px">';
$tglSearch = inputDate('tanggal1', $tanggal1);
$tglSearch .= '<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"> sampai </div>';
$tglSearch .= inputDate('tanggal2', $tanggal2);
$tglSearch .= '<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="transaksi_get()">';
$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>".');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('!Tanggal/<br/>No. Transaksi{110px}', 'Uraian', 'Detil Jurnal');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
if ($r['jenis'] == JT_INCOME) {
$cl = '#00c804';
$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);
$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;
}
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");
$db->where("aka_alumni.tahunlulus='{$tlulus}'");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata_db($t);
$t = $db->query($xtable->pageorder_sql('nisn', 'nama', 'angkatan'));
$xtable->btnbar_f('add', 'srcbox');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('@!NISN', '@nama', '@angkatan{C}', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
//$t1=dbQSql("SELECT * FROM aka_siswa WHERE replid='".$r['siswa']."' LIMIT 0,1");
//$r1=dbFA($t1);
//$xtable->td($r['nis'],80);
$xtable->td($r['nisn'], 120);
$xtable->td($r['nama'], 300);
$xtable->td($r['nangkatan'], 80, 'c');
$xtable->td(nl2br($r['keterangan']));
//$xtable->td($r['tmplahir'].', '.fftgl($r['tgllahir']),100);
//$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_pendataan_kelas_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>';
